Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,901–18,925 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18901 | 9269 | 1 | 2019-12-20 15:52:39 |
| 18902 | 9259 | 2 | 2019-12-20 15:54:13 |
| 18903 | 9254 | 2 | 2019-12-20 15:55:09 |
| 18904 | 9247 | 2 | 2019-12-20 15:57:39 |
| 18905 | 9241 | 2 | 2019-12-20 15:59:01 |
| 18906 | 9260 | 2 | 2019-12-20 15:59:04 |
| 18907 | 9281 | 2 | 2019-12-20 16:01:26 |
| 18908 | 9284 | 2 | 2019-12-20 16:04:45 |
| 18909 | 9285 | 2 | 2019-12-20 16:05:23 |
| 18910 | 9262 | 2 | 2019-12-20 16:07:31 |
| 18911 | 9290 | 2 | 2019-12-20 16:08:15 |
| 18912 | 9248 | 2 | 2019-12-20 16:08:48 |
| 18913 | 9255 | 2 | 2019-12-20 16:11:01 |
| 18914 | 9263 | 2 | 2019-12-20 16:11:50 |
| 18915 | 9256 | 2 | 2019-12-20 16:13:15 |
| 18916 | 9279 | 2 | 2019-12-20 16:13:47 |
| 18917 | 9243 | 2 | 2019-12-20 16:17:23 |
| 18918 | 9245 | 2 | 2019-12-20 16:19:02 |
| 18919 | 9276 | 2 | 2019-12-20 16:19:11 |
| 18920 | 9282 | 2 | 2019-12-20 16:20:43 |
| 18921 | 9268 | 2 | 2019-12-20 16:23:05 |
| 18922 | 9269 | 2 | 2019-12-20 16:25:39 |
| 18923 | 9272 | 2 | 2019-12-20 16:30:02 |
| 18924 | 9289 | 2 | 2019-12-20 16:30:28 |
| 18925 | 9287 | 2 | 2019-12-20 16:31:37 |
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;