Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,826–9,850 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9826 | 5059 | 3 | 2018-01-05 14:26:37 |
| 9827 | 5058 | 3 | 2018-01-05 14:27:49 |
| 9828 | 5037 | 2 | 2018-01-06 11:26:50 |
| 9829 | 5037 | 3 | 2018-01-06 11:57:54 |
| 9830 | 4980 | 2 | 2018-01-06 12:46:57 |
| 9831 | 4979 | 1 | 2018-01-06 12:55:37 |
| 9832 | 5066 | 2 | 2018-01-07 11:16:36 |
| 9833 | 5066 | 1 | 2018-01-07 11:43:50 |
| 9834 | 5066 | 3 | 2018-01-07 13:09:36 |
| 9835 | 5056 | 2 | 2018-01-07 13:26:30 |
| 9836 | 5054 | 2 | 2018-01-07 13:38:11 |
| 9837 | 5053 | 2 | 2018-01-07 13:39:12 |
| 9838 | 5055 | 2 | 2018-01-07 13:40:30 |
| 9839 | 5066 | 1 | 2018-01-07 14:26:25 |
| 9840 | 5040 | 1 | 2018-01-07 15:22:13 |
| 9841 | 5041 | 1 | 2018-01-07 15:28:10 |
| 9842 | 5040 | 2 | 2018-01-07 16:08:44 |
| 9843 | 5041 | 3 | 2018-01-07 17:01:11 |
| 9844 | 5047 | 2 | 2018-01-08 09:31:59 |
| 9845 | 5051 | 2 | 2018-01-08 09:33:47 |
| 9846 | 5048 | 2 | 2018-01-08 09:40:13 |
| 9847 | 5050 | 2 | 2018-01-08 09:44:07 |
| 9848 | 5049 | 2 | 2018-01-08 09:46:34 |
| 9849 | 5050 | 3 | 2018-01-08 10:52:59 |
| 9850 | 5035 | 2 | 2018-01-08 13:45:28 |
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;