Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,001–12,025 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12001 | 6254 | 2 | 2018-07-18 12:26:41 |
| 12002 | 6259 | 1 | 2018-07-18 12:44:37 |
| 12003 | 6258 | 1 | 2018-07-18 13:06:48 |
| 12004 | 6253 | 3 | 2018-07-18 13:10:51 |
| 12005 | 6257 | 1 | 2018-07-18 13:38:58 |
| 12006 | 6253 | 2 | 2018-07-18 13:46:20 |
| 12007 | 6259 | 2 | 2018-07-18 14:13:03 |
| 12008 | 6258 | 3 | 2018-07-18 14:33:10 |
| 12009 | 6257 | 3 | 2018-07-18 14:46:54 |
| 12010 | 6258 | 2 | 2018-07-18 15:15:47 |
| 12011 | 6257 | 2 | 2018-07-18 15:46:50 |
| 12012 | 6261 | 1 | 2018-07-18 16:55:44 |
| 12013 | 6260 | 1 | 2018-07-18 17:00:03 |
| 12014 | 6200 | 2 | 2018-07-18 17:12:06 |
| 12015 | 6199 | 2 | 2018-07-18 17:12:29 |
| 12016 | 6201 | 2 | 2018-07-18 17:13:18 |
| 12017 | 6267 | 2 | 2018-07-19 09:43:10 |
| 12018 | 6266 | 2 | 2018-07-19 09:51:19 |
| 12019 | 6266 | 1 | 2018-07-19 10:28:08 |
| 12020 | 6267 | 1 | 2018-07-19 10:44:29 |
| 12021 | 6088 | 2 | 2018-07-19 10:57:15 |
| 12022 | 6089 | 3 | 2018-07-19 11:03:51 |
| 12023 | 6266 | 2 | 2018-07-19 11:11:03 |
| 12024 | 6089 | 1 | 2018-07-19 11:30:15 |
| 12025 | 6088 | 1 | 2018-07-19 12:00:45 |
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;