Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,501–17,525 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17501 | 8857 | 2 | 2019-08-30 10:44:02 |
| 17502 | 8854 | 1 | 2019-08-30 11:05:49 |
| 17503 | 8856 | 1 | 2019-08-30 11:11:55 |
| 17504 | 8858 | 3 | 2019-08-30 11:19:16 |
| 17505 | 8858 | 2 | 2019-08-30 12:39:18 |
| 17506 | 8864 | 1 | 2019-08-31 10:21:12 |
| 17507 | 8865 | 3 | 2019-08-31 10:31:32 |
| 17508 | 8828 | 2 | 2019-08-31 10:32:21 |
| 17509 | 8825 | 1 | 2019-08-31 10:40:02 |
| 17510 | 8866 | 1 | 2019-08-31 10:40:56 |
| 17511 | 8827 | 1 | 2019-08-31 10:41:02 |
| 17512 | 8826 | 1 | 2019-08-31 10:41:57 |
| 17513 | 8824 | 1 | 2019-08-31 10:47:28 |
| 17514 | 8867 | 3 | 2019-08-31 10:48:42 |
| 17515 | 8866 | 3 | 2019-08-31 11:19:43 |
| 17516 | 8867 | 1 | 2019-08-31 11:22:19 |
| 17517 | 8865 | 2 | 2019-08-31 11:24:04 |
| 17518 | 8827 | 3 | 2019-08-31 11:52:12 |
| 17519 | 8867 | 3 | 2019-08-31 12:05:22 |
| 17520 | 8866 | 1 | 2019-08-31 12:19:46 |
| 17521 | 8852 | 1 | 2019-08-31 12:40:50 |
| 17522 | 8853 | 2 | 2019-08-31 12:45:29 |
| 17523 | 8865 | 1 | 2019-08-31 12:55:24 |
| 17524 | 8813 | 3 | 2019-08-31 13:11:37 |
| 17525 | 8812 | 3 | 2019-08-31 13:14:05 |
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;