Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,126–18,150 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18126 | 8928 | 2 | 2019-11-05 10:23:09 |
| 18127 | 8932 | 2 | 2019-11-05 10:23:11 |
| 18128 | 8936 | 2 | 2019-11-05 10:23:24 |
| 18129 | 8912 | 2 | 2019-11-05 10:23:30 |
| 18130 | 8945 | 2 | 2019-11-05 10:24:44 |
| 18131 | 8937 | 2 | 2019-11-05 10:25:12 |
| 18132 | 8903 | 2 | 2019-11-05 10:25:22 |
| 18133 | 8909 | 2 | 2019-11-05 10:25:33 |
| 18134 | 8920 | 2 | 2019-11-05 10:25:59 |
| 18135 | 8943 | 2 | 2019-11-05 10:27:59 |
| 18136 | 9367 | 2 | 2019-11-06 09:24:02 |
| 18137 | 9366 | 3 | 2019-11-06 09:24:24 |
| 18138 | 9337 | 1 | 2019-11-06 09:48:24 |
| 18139 | 9338 | 2 | 2019-11-06 09:53:36 |
| 18140 | 9337 | 3 | 2019-11-06 10:13:55 |
| 18141 | 9367 | 3 | 2019-11-06 10:55:29 |
| 18142 | 9369 | 2 | 2019-11-07 09:23:24 |
| 18143 | 9368 | 2 | 2019-11-07 09:32:55 |
| 18144 | 9358 | 2 | 2019-11-07 09:57:15 |
| 18145 | 9357 | 2 | 2019-11-07 10:05:43 |
| 18146 | 9346 | 2 | 2019-11-07 13:03:11 |
| 18147 | 9347 | 2 | 2019-11-07 13:07:20 |
| 18148 | 9370 | 2 | 2019-11-07 14:15:31 |
| 18149 | 9370 | 3 | 2019-11-07 15:44:21 |
| 18150 | 9374 | 1 | 2019-11-08 10:25:54 |
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;