Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,051–5,075 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5051 | 2556 | 1 | 2016-07-27 12:32:46 |
| 5052 | 2555 | 1 | 2016-07-27 13:10:28 |
| 5053 | 2518 | 2 | 2016-07-27 13:23:49 |
| 5054 | 2516 | 3 | 2016-07-27 13:27:30 |
| 5055 | 2556 | 3 | 2016-07-27 13:30:06 |
| 5056 | 2517 | 3 | 2016-07-27 13:36:44 |
| 5057 | 2517 | 2 | 2016-07-27 14:12:35 |
| 5058 | 2516 | 2 | 2016-07-27 14:37:10 |
| 5059 | 2555 | 3 | 2016-07-27 14:39:02 |
| 5060 | 2517 | 1 | 2016-07-27 15:12:34 |
| 5061 | 2516 | 1 | 2016-07-27 15:49:42 |
| 5062 | 2564 | 2 | 2016-07-28 10:13:32 |
| 5063 | 2567 | 2 | 2016-07-28 11:37:05 |
| 5064 | 2565 | 2 | 2016-07-28 11:41:10 |
| 5065 | 2566 | 2 | 2016-07-28 11:50:49 |
| 5066 | 2567 | 1 | 2016-07-28 12:48:37 |
| 5067 | 2565 | 1 | 2016-07-28 12:55:04 |
| 5068 | 2566 | 1 | 2016-07-28 13:18:42 |
| 5069 | 2534 | 2 | 2016-07-29 14:18:56 |
| 5070 | 2571 | 2 | 2016-07-30 16:42:25 |
| 5071 | 2570 | 2 | 2016-07-30 16:43:29 |
| 5072 | 2571 | 3 | 2016-07-30 17:36:30 |
| 5073 | 2570 | 3 | 2016-07-30 17:39:12 |
| 5074 | 2560 | 3 | 2016-07-31 09:49:19 |
| 5075 | 2445 | 2 | 2016-07-31 10:47:30 |
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;