Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 19,351–19,375 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 19351 | 9759 | 3 | 2020-02-02 11:13:16 |
| 19352 | 9760 | 1 | 2020-02-02 11:31:02 |
| 19353 | 9759 | 1 | 2020-02-02 12:21:35 |
| 19354 | 9762 | 3 | 2020-02-02 12:52:57 |
| 19355 | 9761 | 2 | 2020-02-02 13:02:42 |
| 19356 | 9761 | 3 | 2020-02-02 14:00:26 |
| 19357 | 9765 | 2 | 2020-02-02 16:31:41 |
| 19358 | 9764 | 3 | 2020-02-02 16:38:37 |
| 19359 | 9763 | 3 | 2020-02-02 16:43:18 |
| 19360 | 9765 | 3 | 2020-02-02 17:07:51 |
| 19361 | 9767 | 2 | 2020-02-04 09:14:12 |
| 19362 | 9768 | 2 | 2020-02-04 09:16:59 |
| 19363 | 9766 | 2 | 2020-02-04 09:23:35 |
| 19364 | 9767 | 3 | 2020-02-04 09:55:02 |
| 19365 | 9768 | 3 | 2020-02-04 09:58:30 |
| 19366 | 9766 | 3 | 2020-02-04 10:52:50 |
| 19367 | 9767 | 2 | 2020-02-04 11:01:33 |
| 19368 | 9768 | 2 | 2020-02-04 11:04:31 |
| 19369 | 9766 | 2 | 2020-02-04 11:23:54 |
| 19370 | 9751 | 2 | 2020-02-04 14:51:14 |
| 19371 | 9758 | 2 | 2020-02-05 12:16:22 |
| 19372 | 9744 | 1 | 2020-02-05 12:31:50 |
| 19373 | 9743 | 3 | 2020-02-05 12:42:32 |
| 19374 | 9742 | 2 | 2020-02-05 12:46:22 |
| 19375 | 9744 | 3 | 2020-02-05 13:04:33 |
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;