Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,326–1,350 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1326 | 773 | 3 | 2015-07-11 11:34:35 |
| 1327 | 772 | 2 | 2015-07-11 11:36:58 |
| 1328 | 774 | 1 | 2015-07-11 11:45:40 |
| 1329 | 775 | 2 | 2015-07-11 12:06:00 |
| 1330 | 771 | 2 | 2015-07-11 12:12:59 |
| 1331 | 774 | 2 | 2015-07-11 13:01:43 |
| 1332 | 718 | 2 | 2015-07-12 11:00:45 |
| 1333 | 779 | 3 | 2015-07-12 14:24:32 |
| 1334 | 781 | 2 | 2015-07-12 14:25:28 |
| 1335 | 780 | 3 | 2015-07-12 14:27:09 |
| 1336 | 786 | 2 | 2015-07-12 14:44:32 |
| 1337 | 783 | 2 | 2015-07-12 14:44:58 |
| 1338 | 784 | 2 | 2015-07-12 14:46:11 |
| 1339 | 785 | 2 | 2015-07-12 14:50:55 |
| 1340 | 782 | 2 | 2015-07-12 14:53:38 |
| 1341 | 781 | 1 | 2015-07-12 15:13:49 |
| 1342 | 784 | 3 | 2015-07-12 15:30:07 |
| 1343 | 781 | 2 | 2015-07-12 16:17:42 |
| 1344 | 781 | 1 | 2015-07-12 17:04:49 |
| 1345 | 787 | 1 | 2015-07-13 09:51:32 |
| 1346 | 778 | 2 | 2015-07-13 10:20:40 |
| 1347 | 787 | 3 | 2015-07-13 10:45:16 |
| 1348 | 787 | 2 | 2015-07-13 11:16:29 |
| 1349 | 789 | 2 | 2015-07-13 11:28:54 |
| 1350 | 778 | 1 | 2015-07-13 11:48:38 |
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;