Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,926–13,950 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13926 | 7200 | 1 | 2018-11-29 11:15:50 |
| 13927 | 7200 | 2 | 2018-11-29 11:53:04 |
| 13928 | 7201 | 2 | 2018-11-29 12:02:48 |
| 13929 | 7169 | 2 | 2018-11-29 12:03:33 |
| 13930 | 7208 | 2 | 2018-11-30 09:25:11 |
| 13931 | 7209 | 1 | 2018-11-30 09:34:19 |
| 13932 | 7212 | 2 | 2018-11-30 12:53:57 |
| 13933 | 7213 | 2 | 2018-11-30 13:02:45 |
| 13934 | 7212 | 1 | 2018-11-30 13:24:47 |
| 13935 | 7179 | 3 | 2018-11-30 13:26:10 |
| 13936 | 7213 | 1 | 2018-11-30 13:29:36 |
| 13937 | 7178 | 3 | 2018-11-30 13:30:17 |
| 13938 | 7179 | 2 | 2018-11-30 13:59:14 |
| 13939 | 7178 | 2 | 2018-11-30 14:57:17 |
| 13940 | 7179 | 3 | 2018-11-30 15:12:25 |
| 13941 | 7178 | 3 | 2018-11-30 15:27:09 |
| 13942 | 7014 | 2 | 2018-12-01 10:26:22 |
| 13943 | 7015 | 2 | 2018-12-01 10:28:01 |
| 13944 | 7016 | 2 | 2018-12-01 10:32:54 |
| 13945 | 7014 | 3 | 2018-12-01 11:08:24 |
| 13946 | 7197 | 2 | 2018-12-01 11:09:55 |
| 13947 | 7196 | 2 | 2018-12-01 11:23:25 |
| 13948 | 7015 | 3 | 2018-12-01 11:36:30 |
| 13949 | 7016 | 3 | 2018-12-01 11:44:54 |
| 13950 | 7187 | 2 | 2018-12-02 09:21:50 |
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;