Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,276–16,300 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16276 | 8299 | 3 | 2019-05-31 14:32:04 |
| 16277 | 8026 | 2 | 2019-05-31 14:32:28 |
| 16278 | 8033 | 2 | 2019-05-31 14:32:28 |
| 16279 | 8007 | 2 | 2019-05-31 14:33:39 |
| 16280 | 8025 | 2 | 2019-05-31 14:34:52 |
| 16281 | 8028 | 2 | 2019-05-31 14:35:38 |
| 16282 | 7998 | 2 | 2019-05-31 14:37:47 |
| 16283 | 8022 | 3 | 2019-05-31 14:37:58 |
| 16284 | 8024 | 2 | 2019-05-31 14:39:20 |
| 16285 | 8013 | 2 | 2019-05-31 14:41:20 |
| 16286 | 7999 | 2 | 2019-05-31 14:41:25 |
| 16287 | 8017 | 3 | 2019-05-31 14:42:27 |
| 16288 | 8027 | 2 | 2019-05-31 14:43:28 |
| 16289 | 8012 | 3 | 2019-05-31 14:44:19 |
| 16290 | 8004 | 3 | 2019-05-31 14:45:31 |
| 16291 | 8010 | 2 | 2019-05-31 14:51:45 |
| 16292 | 8000 | 2 | 2019-05-31 14:56:31 |
| 16293 | 8008 | 2 | 2019-05-31 14:56:51 |
| 16294 | 8021 | 3 | 2019-05-31 14:59:40 |
| 16295 | 8016 | 3 | 2019-05-31 15:00:19 |
| 16296 | 8026 | 3 | 2019-05-31 15:05:19 |
| 16297 | 7998 | 3 | 2019-05-31 15:05:43 |
| 16298 | 8034 | 3 | 2019-05-31 15:07:19 |
| 16299 | 8006 | 3 | 2019-05-31 15:08:59 |
| 16300 | 8023 | 3 | 2019-05-31 15:09:20 |
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;