Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,251–16,275 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16251 | 8020 | 1 | 2019-05-31 13:48:54 |
| 16252 | 8299 | 1 | 2019-05-31 13:51:00 |
| 16253 | 8006 | 2 | 2019-05-31 13:52:09 |
| 16254 | 8005 | 3 | 2019-05-31 13:52:36 |
| 16255 | 8019 | 2 | 2019-05-31 13:54:00 |
| 16256 | 7997 | 2 | 2019-05-31 13:55:38 |
| 16257 | 8022 | 2 | 2019-05-31 13:59:28 |
| 16258 | 8004 | 2 | 2019-05-31 14:02:04 |
| 16259 | 8034 | 2 | 2019-05-31 14:05:18 |
| 16260 | 8021 | 2 | 2019-05-31 14:07:33 |
| 16261 | 8012 | 2 | 2019-05-31 14:08:34 |
| 16262 | 8018 | 2 | 2019-05-31 14:15:36 |
| 16263 | 8032 | 2 | 2019-05-31 14:16:32 |
| 16264 | 8023 | 2 | 2019-05-31 14:18:02 |
| 16265 | 8031 | 2 | 2019-05-31 14:18:45 |
| 16266 | 8015 | 2 | 2019-05-31 14:19:56 |
| 16267 | 7997 | 3 | 2019-05-31 14:21:36 |
| 16268 | 8030 | 2 | 2019-05-31 14:21:39 |
| 16269 | 8001 | 2 | 2019-05-31 14:25:13 |
| 16270 | 8016 | 2 | 2019-05-31 14:26:12 |
| 16271 | 8011 | 2 | 2019-05-31 14:26:16 |
| 16272 | 8014 | 2 | 2019-05-31 14:26:19 |
| 16273 | 8019 | 3 | 2019-05-31 14:27:40 |
| 16274 | 8003 | 3 | 2019-05-31 14:29:07 |
| 16275 | 8029 | 2 | 2019-05-31 14:31:43 |
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;