Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,826–12,850 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12826 | 6572 | 1 | 2018-08-30 10:31:20 |
| 12827 | 6572 | 2 | 2018-08-30 11:05:06 |
| 12828 | 6571 | 2 | 2018-08-30 11:05:56 |
| 12829 | 6582 | 3 | 2018-08-30 11:09:57 |
| 12830 | 6585 | 2 | 2018-08-30 11:14:08 |
| 12831 | 6586 | 2 | 2018-08-30 11:21:14 |
| 12832 | 6586 | 1 | 2018-08-30 11:53:55 |
| 12833 | 6586 | 3 | 2018-08-30 12:23:13 |
| 12834 | 6585 | 3 | 2018-08-30 12:37:55 |
| 12835 | 6585 | 2 | 2018-08-30 13:11:19 |
| 12836 | 6594 | 2 | 2018-08-31 09:50:52 |
| 12837 | 6596 | 2 | 2018-08-31 09:51:51 |
| 12838 | 6593 | 2 | 2018-08-31 09:52:53 |
| 12839 | 6358 | 2 | 2018-08-31 09:55:40 |
| 12840 | 6595 | 1 | 2018-08-31 09:58:09 |
| 12841 | 6362 | 2 | 2018-08-31 09:58:56 |
| 12842 | 6371 | 2 | 2018-08-31 09:59:33 |
| 12843 | 6366 | 2 | 2018-08-31 09:59:50 |
| 12844 | 6379 | 2 | 2018-08-31 10:00:40 |
| 12845 | 6378 | 2 | 2018-08-31 10:01:47 |
| 12846 | 6385 | 2 | 2018-08-31 10:01:56 |
| 12847 | 6383 | 2 | 2018-08-31 10:02:19 |
| 12848 | 6360 | 2 | 2018-08-31 10:02:59 |
| 12849 | 6357 | 2 | 2018-08-31 10:03:57 |
| 12850 | 6597 | 2 | 2018-08-31 10:04:03 |
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;