Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,601–3,625 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3601 | 1863 | 2 | 2016-03-06 13:18:44 |
| 3602 | 1861 | 2 | 2016-03-06 13:42:25 |
| 3603 | 1866 | 2 | 2016-03-07 10:34:21 |
| 3604 | 1867 | 3 | 2016-03-07 10:40:31 |
| 3605 | 1808 | 2 | 2016-03-08 10:17:43 |
| 3606 | 1808 | 1 | 2016-03-08 10:54:41 |
| 3607 | 1808 | 3 | 2016-03-08 11:33:21 |
| 3608 | 1879 | 2 | 2016-03-09 13:12:55 |
| 3609 | 1878 | 3 | 2016-03-09 13:15:10 |
| 3610 | 1879 | 3 | 2016-03-09 14:17:06 |
| 3611 | 1878 | 1 | 2016-03-09 14:50:09 |
| 3612 | 1879 | 1 | 2016-03-09 15:36:51 |
| 3613 | 1837 | 2 | 2016-03-10 11:19:37 |
| 3614 | 1838 | 2 | 2016-03-10 11:19:57 |
| 3615 | 1839 | 2 | 2016-03-10 11:25:14 |
| 3616 | 1868 | 2 | 2016-03-10 12:34:33 |
| 3617 | 1870 | 2 | 2016-03-10 12:36:13 |
| 3618 | 1869 | 2 | 2016-03-10 12:39:22 |
| 3619 | 1871 | 2 | 2016-03-10 12:48:49 |
| 3620 | 1868 | 3 | 2016-03-10 13:18:51 |
| 3621 | 1870 | 3 | 2016-03-10 13:39:14 |
| 3622 | 1869 | 3 | 2016-03-10 14:07:09 |
| 3623 | 1871 | 3 | 2016-03-10 14:21:37 |
| 3624 | 1868 | 1 | 2016-03-10 14:32:21 |
| 3625 | 1870 | 1 | 2016-03-10 15:08:14 |
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;