Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,926–15,950 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15926 | 8135 | 2 | 2019-05-06 13:43:46 |
| 15927 | 8134 | 2 | 2019-05-06 13:59:57 |
| 15928 | 8187 | 2 | 2019-05-07 15:13:49 |
| 15929 | 8186 | 2 | 2019-05-07 15:14:00 |
| 15930 | 8186 | 1 | 2019-05-07 15:43:19 |
| 15931 | 8186 | 2 | 2019-05-07 17:05:59 |
| 15932 | 8186 | 3 | 2019-05-07 17:43:29 |
| 15933 | 8200 | 2 | 2019-05-09 10:00:12 |
| 15934 | 8199 | 2 | 2019-05-09 10:02:19 |
| 15935 | 8200 | 3 | 2019-05-09 10:49:47 |
| 15936 | 8201 | 2 | 2019-05-09 11:25:49 |
| 15937 | 8202 | 2 | 2019-05-09 11:36:40 |
| 15938 | 8200 | 1 | 2019-05-09 11:40:02 |
| 15939 | 8183 | 1 | 2019-05-10 10:56:57 |
| 15940 | 8184 | 1 | 2019-05-10 10:57:23 |
| 15941 | 8182 | 3 | 2019-05-10 10:59:54 |
| 15942 | 8185 | 1 | 2019-05-10 11:01:33 |
| 15943 | 8122 | 2 | 2019-05-10 11:10:43 |
| 15944 | 8123 | 2 | 2019-05-10 11:20:19 |
| 15945 | 8185 | 3 | 2019-05-10 11:35:45 |
| 15946 | 8182 | 2 | 2019-05-10 11:53:12 |
| 15947 | 8092 | 1 | 2019-05-10 16:31:30 |
| 15948 | 8090 | 1 | 2019-05-10 16:32:26 |
| 15949 | 8091 | 1 | 2019-05-10 16:33:31 |
| 15950 | 8091 | 2 | 2019-05-10 17:07:36 |
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;