Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,826–15,850 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15826 | 8125 | 1 | 2019-04-26 12:00:15 |
| 15827 | 8133 | 3 | 2019-04-26 12:04:38 |
| 15828 | 8133 | 1 | 2019-04-26 12:33:26 |
| 15829 | 8124 | 1 | 2019-04-26 12:47:42 |
| 15830 | 8101 | 1 | 2019-04-27 12:01:26 |
| 15831 | 8132 | 2 | 2019-04-28 09:47:18 |
| 15832 | 8131 | 2 | 2019-04-28 09:47:42 |
| 15833 | 8132 | 1 | 2019-04-28 10:32:44 |
| 15834 | 8141 | 2 | 2019-04-29 12:05:07 |
| 15835 | 8142 | 2 | 2019-04-29 12:08:12 |
| 15836 | 8058 | 2 | 2019-04-29 12:33:44 |
| 15837 | 8059 | 2 | 2019-04-29 12:42:38 |
| 15838 | 8141 | 3 | 2019-04-29 12:43:57 |
| 15839 | 8057 | 2 | 2019-04-29 12:47:21 |
| 15840 | 8060 | 2 | 2019-04-29 12:47:34 |
| 15841 | 8142 | 3 | 2019-04-29 13:02:57 |
| 15842 | 8058 | 1 | 2019-04-29 13:13:59 |
| 15843 | 8059 | 1 | 2019-04-29 13:46:02 |
| 15844 | 8060 | 1 | 2019-04-29 14:05:49 |
| 15845 | 8057 | 1 | 2019-04-29 14:22:39 |
| 15846 | 8144 | 1 | 2019-04-29 14:49:15 |
| 15847 | 8145 | 3 | 2019-04-29 14:52:49 |
| 15848 | 8144 | 2 | 2019-04-29 16:20:25 |
| 15849 | 8148 | 2 | 2019-04-30 10:32:36 |
| 15850 | 8147 | 1 | 2019-04-30 10:38:58 |
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;