Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,451–3,475 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3451 | 1810 | 2 | 2016-02-17 16:06:42 |
| 3452 | 1809 | 2 | 2016-02-17 16:10:38 |
| 3453 | 1811 | 2 | 2016-02-17 16:13:22 |
| 3454 | 1809 | 1 | 2016-02-17 17:19:46 |
| 3455 | 1811 | 3 | 2016-02-17 17:39:28 |
| 3456 | 1813 | 2 | 2016-02-18 11:51:18 |
| 3457 | 1812 | 2 | 2016-02-18 12:02:36 |
| 3458 | 1815 | 2 | 2016-02-18 12:03:52 |
| 3459 | 1814 | 2 | 2016-02-18 12:04:25 |
| 3460 | 1812 | 1 | 2016-02-18 12:49:10 |
| 3461 | 1814 | 1 | 2016-02-18 12:51:59 |
| 3462 | 1813 | 1 | 2016-02-18 13:17:11 |
| 3463 | 1815 | 1 | 2016-02-18 13:22:22 |
| 3464 | 1778 | 2 | 2016-02-18 13:40:00 |
| 3465 | 1778 | 3 | 2016-02-18 14:59:31 |
| 3466 | 1816 | 2 | 2016-02-18 15:41:15 |
| 3467 | 1817 | 2 | 2016-02-18 15:44:07 |
| 3468 | 1818 | 3 | 2016-02-18 15:45:47 |
| 3469 | 1819 | 2 | 2016-02-18 15:53:01 |
| 3470 | 1816 | 3 | 2016-02-18 16:54:17 |
| 3471 | 1818 | 2 | 2016-02-18 17:01:55 |
| 3472 | 1817 | 3 | 2016-02-18 17:09:09 |
| 3473 | 1816 | 2 | 2016-02-18 17:21:04 |
| 3474 | 1819 | 3 | 2016-02-18 17:27:25 |
| 3475 | 1821 | 1 | 2016-02-19 10:45:23 |
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;