Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,176–1,200 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1176 | 720 | 3 | 2015-06-27 12:35:19 |
| 1177 | 719 | 3 | 2015-06-27 12:44:49 |
| 1178 | 721 | 2 | 2015-06-27 13:15:11 |
| 1179 | 722 | 2 | 2015-06-28 10:56:51 |
| 1180 | 723 | 2 | 2015-06-28 11:04:57 |
| 1181 | 724 | 2 | 2015-06-28 11:05:06 |
| 1182 | 723 | 1 | 2015-06-28 11:38:49 |
| 1183 | 722 | 3 | 2015-06-28 11:49:23 |
| 1184 | 724 | 3 | 2015-06-28 11:51:00 |
| 1185 | 725 | 2 | 2015-06-28 11:52:55 |
| 1186 | 725 | 3 | 2015-06-28 12:20:36 |
| 1187 | 723 | 3 | 2015-06-28 12:28:06 |
| 1188 | 726 | 1 | 2015-06-28 12:44:24 |
| 1189 | 725 | 2 | 2015-06-28 13:02:09 |
| 1190 | 726 | 3 | 2015-06-28 13:37:38 |
| 1191 | 727 | 3 | 2015-06-28 13:49:23 |
| 1192 | 725 | 3 | 2015-06-28 13:50:28 |
| 1193 | 723 | 1 | 2015-06-28 13:50:49 |
| 1194 | 727 | 1 | 2015-06-28 14:27:33 |
| 1195 | 727 | 2 | 2015-06-28 15:28:10 |
| 1196 | 178 | 1 | 2015-06-30 13:57:42 |
| 1197 | 191 | 1 | 2015-06-30 13:58:12 |
| 1198 | 179 | 1 | 2015-06-30 13:58:50 |
| 1199 | 183 | 1 | 2015-06-30 13:58:53 |
| 1200 | 172 | 1 | 2015-06-30 13:59:12 |
Table definition
CREATE TABLE wing_scan (
scan_id INTEGER PRIMARY KEY,
ticket_id INTEGER NOT NULL REFERENCES ticket (ticket_id),
wing_id INTEGER NOT NULL REFERENCES wing (wing_id),
scanned_at TEXT NOT NULL
) STRICT;