Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,226–16,250 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16226 | 8025 | 1 | 2019-05-31 13:20:40 |
| 16227 | 8003 | 2 | 2019-05-31 13:20:51 |
| 16228 | 8027 | 1 | 2019-05-31 13:23:04 |
| 16229 | 8008 | 1 | 2019-05-31 13:25:19 |
| 16230 | 8013 | 1 | 2019-05-31 13:25:41 |
| 16231 | 8010 | 1 | 2019-05-31 13:25:45 |
| 16232 | 8029 | 1 | 2019-05-31 13:26:00 |
| 16233 | 8033 | 1 | 2019-05-31 13:27:03 |
| 16234 | 8019 | 1 | 2019-05-31 13:27:18 |
| 16235 | 8017 | 2 | 2019-05-31 13:27:20 |
| 16236 | 8023 | 1 | 2019-05-31 13:29:18 |
| 16237 | 8012 | 1 | 2019-05-31 13:29:24 |
| 16238 | 8026 | 1 | 2019-05-31 13:29:37 |
| 16239 | 8022 | 1 | 2019-05-31 13:30:05 |
| 16240 | 8014 | 1 | 2019-05-31 13:31:03 |
| 16241 | 8266 | 1 | 2019-05-31 13:33:33 |
| 16242 | 8000 | 1 | 2019-05-31 13:34:11 |
| 16243 | 8016 | 1 | 2019-05-31 13:37:10 |
| 16244 | 8024 | 1 | 2019-05-31 13:40:16 |
| 16245 | 7999 | 1 | 2019-05-31 13:41:24 |
| 16246 | 8002 | 1 | 2019-05-31 13:42:28 |
| 16247 | 8031 | 1 | 2019-05-31 13:42:41 |
| 16248 | 8009 | 1 | 2019-05-31 13:43:00 |
| 16249 | 8007 | 1 | 2019-05-31 13:43:28 |
| 16250 | 8011 | 1 | 2019-05-31 13:46:15 |
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;