Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,501–3,525 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3501 | 1746 | 1 | 2016-02-27 13:06:26 |
| 3502 | 1747 | 1 | 2016-02-27 13:12:11 |
| 3503 | 1745 | 1 | 2016-02-27 13:26:21 |
| 3504 | 1832 | 2 | 2016-02-27 13:30:23 |
| 3505 | 1835 | 2 | 2016-02-27 13:31:24 |
| 3506 | 1833 | 2 | 2016-02-27 13:31:46 |
| 3507 | 1834 | 2 | 2016-02-27 13:33:53 |
| 3508 | 1836 | 2 | 2016-02-27 13:39:32 |
| 3509 | 1835 | 3 | 2016-02-27 13:58:03 |
| 3510 | 1748 | 2 | 2016-02-27 14:16:44 |
| 3511 | 1835 | 2 | 2016-02-27 14:26:33 |
| 3512 | 1747 | 2 | 2016-02-27 14:28:23 |
| 3513 | 1746 | 2 | 2016-02-27 14:31:46 |
| 3514 | 1745 | 2 | 2016-02-27 14:35:01 |
| 3515 | 1836 | 3 | 2016-02-27 14:37:51 |
| 3516 | 1832 | 3 | 2016-02-27 14:40:14 |
| 3517 | 1834 | 3 | 2016-02-27 14:52:43 |
| 3518 | 1832 | 2 | 2016-02-27 15:12:08 |
| 3519 | 1836 | 2 | 2016-02-27 15:38:36 |
| 3520 | 1834 | 2 | 2016-02-27 15:50:21 |
| 3521 | 1841 | 2 | 2016-02-29 14:04:05 |
| 3522 | 1842 | 2 | 2016-02-29 14:05:43 |
| 3523 | 1840 | 2 | 2016-02-29 14:06:12 |
| 3524 | 1843 | 1 | 2016-02-29 14:15:58 |
| 3525 | 1840 | 3 | 2016-02-29 14:43:04 |
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;