Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,876–16,900 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16876 | 7947 | 3 | 2019-07-14 13:16:34 |
| 16877 | 7933 | 3 | 2019-07-14 13:16:45 |
| 16878 | 7965 | 3 | 2019-07-14 13:18:09 |
| 16879 | 7967 | 3 | 2019-07-14 13:21:20 |
| 16880 | 7952 | 3 | 2019-07-14 13:22:35 |
| 16881 | 7950 | 3 | 2019-07-14 13:23:22 |
| 16882 | 7964 | 3 | 2019-07-14 13:23:58 |
| 16883 | 7945 | 3 | 2019-07-14 13:30:51 |
| 16884 | 7970 | 3 | 2019-07-14 13:36:58 |
| 16885 | 7955 | 3 | 2019-07-14 13:38:08 |
| 16886 | 7939 | 3 | 2019-07-14 13:42:01 |
| 16887 | 7954 | 3 | 2019-07-14 13:46:16 |
| 16888 | 7960 | 3 | 2019-07-14 13:46:36 |
| 16889 | 7936 | 3 | 2019-07-14 13:47:55 |
| 16890 | 7937 | 3 | 2019-07-14 13:51:20 |
| 16891 | 7932 | 3 | 2019-07-14 13:52:35 |
| 16892 | 7957 | 3 | 2019-07-14 13:58:57 |
| 16893 | 7942 | 3 | 2019-07-14 14:21:19 |
| 16894 | 7951 | 3 | 2019-07-14 14:23:14 |
| 16895 | 7949 | 3 | 2019-07-14 14:28:34 |
| 16896 | 7935 | 3 | 2019-07-14 14:33:52 |
| 16897 | 8556 | 2 | 2019-07-14 15:19:58 |
| 16898 | 8557 | 2 | 2019-07-14 15:23:24 |
| 16899 | 8495 | 2 | 2019-07-15 09:39:45 |
| 16900 | 8494 | 2 | 2019-07-15 09:42:32 |
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;