Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,801–16,825 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16801 | 7964 | 2 | 2019-07-14 11:28:30 |
| 16802 | 7962 | 2 | 2019-07-14 11:28:42 |
| 16803 | 7961 | 2 | 2019-07-14 11:29:20 |
| 16804 | 7963 | 2 | 2019-07-14 11:30:40 |
| 16805 | 7956 | 2 | 2019-07-14 11:30:57 |
| 16806 | 7970 | 2 | 2019-07-14 11:34:32 |
| 16807 | 8554 | 1 | 2019-07-14 11:35:32 |
| 16808 | 8555 | 2 | 2019-07-14 11:41:16 |
| 16809 | 8547 | 3 | 2019-07-14 11:41:30 |
| 16810 | 8548 | 2 | 2019-07-14 11:43:10 |
| 16811 | 7950 | 1 | 2019-07-14 11:51:42 |
| 16812 | 7933 | 1 | 2019-07-14 11:55:03 |
| 16813 | 7961 | 1 | 2019-07-14 11:55:32 |
| 16814 | 7972 | 1 | 2019-07-14 12:02:09 |
| 16815 | 7958 | 1 | 2019-07-14 12:02:44 |
| 16816 | 7940 | 1 | 2019-07-14 12:03:49 |
| 16817 | 7943 | 1 | 2019-07-14 12:05:56 |
| 16818 | 7941 | 1 | 2019-07-14 12:06:09 |
| 16819 | 7968 | 1 | 2019-07-14 12:08:08 |
| 16820 | 7962 | 1 | 2019-07-14 12:10:16 |
| 16821 | 7969 | 1 | 2019-07-14 12:12:07 |
| 16822 | 7959 | 1 | 2019-07-14 12:12:09 |
| 16823 | 7967 | 1 | 2019-07-14 12:15:12 |
| 16824 | 7966 | 1 | 2019-07-14 12:15:43 |
| 16825 | 7938 | 1 | 2019-07-14 12:15:52 |
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;