Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 19,001–19,025 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 19001 | 9587 | 2 | 2019-12-25 15:44:52 |
| 19002 | 9583 | 1 | 2019-12-25 15:45:07 |
| 19003 | 9599 | 1 | 2019-12-25 16:05:58 |
| 19004 | 9600 | 1 | 2019-12-25 16:11:44 |
| 19005 | 9585 | 2 | 2019-12-25 16:23:28 |
| 19006 | 9586 | 2 | 2019-12-25 16:32:36 |
| 19007 | 9583 | 2 | 2019-12-25 16:43:14 |
| 19008 | 9585 | 3 | 2019-12-25 16:52:01 |
| 19009 | 9584 | 2 | 2019-12-25 17:08:08 |
| 19010 | 9599 | 3 | 2019-12-25 17:11:49 |
| 19011 | 9583 | 3 | 2019-12-25 17:19:30 |
| 19012 | 9586 | 3 | 2019-12-25 17:22:16 |
| 19013 | 9600 | 3 | 2019-12-25 17:22:49 |
| 19014 | 9417 | 1 | 2019-12-26 12:45:01 |
| 19015 | 9418 | 1 | 2019-12-26 12:45:29 |
| 19016 | 9417 | 3 | 2019-12-26 13:13:21 |
| 19017 | 9418 | 3 | 2019-12-26 13:32:29 |
| 19018 | 9417 | 2 | 2019-12-26 13:54:44 |
| 19019 | 9418 | 2 | 2019-12-26 14:45:27 |
| 19020 | 9417 | 1 | 2019-12-26 15:06:14 |
| 19021 | 9418 | 1 | 2019-12-26 15:49:03 |
| 19022 | 9606 | 2 | 2019-12-27 09:38:24 |
| 19023 | 9605 | 2 | 2019-12-27 09:41:48 |
| 19024 | 9608 | 2 | 2019-12-27 11:25:30 |
| 19025 | 9607 | 2 | 2019-12-27 11:27:26 |
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;