Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,926–18,950 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18926 | 9270 | 2 | 2019-12-20 16:33:18 |
| 18927 | 9283 | 2 | 2019-12-20 16:33:53 |
| 18928 | 9265 | 2 | 2019-12-20 16:34:30 |
| 18929 | 9274 | 2 | 2019-12-20 16:36:21 |
| 18930 | 9267 | 2 | 2019-12-20 16:37:24 |
| 18931 | 9275 | 2 | 2019-12-20 16:39:31 |
| 18932 | 9244 | 2 | 2019-12-20 16:42:14 |
| 18933 | 9249 | 2 | 2019-12-20 16:49:34 |
| 18934 | 9280 | 2 | 2019-12-20 16:49:44 |
| 18935 | 9266 | 2 | 2019-12-20 16:51:45 |
| 18936 | 9273 | 2 | 2019-12-20 16:52:18 |
| 18937 | 9278 | 2 | 2019-12-20 16:59:50 |
| 18938 | 9261 | 2 | 2019-12-20 17:09:13 |
| 18939 | 9250 | 2 | 2019-12-20 17:09:39 |
| 18940 | 9264 | 2 | 2019-12-20 17:10:35 |
| 18941 | 9286 | 2 | 2019-12-20 17:15:30 |
| 18942 | 9288 | 2 | 2019-12-20 17:19:46 |
| 18943 | 9578 | 1 | 2019-12-21 10:03:54 |
| 18944 | 9556 | 2 | 2019-12-21 10:31:15 |
| 18945 | 9509 | 2 | 2019-12-21 10:38:40 |
| 18946 | 9508 | 2 | 2019-12-21 10:40:01 |
| 18947 | 9557 | 2 | 2019-12-21 10:41:33 |
| 18948 | 9578 | 3 | 2019-12-21 11:23:38 |
| 18949 | 9579 | 2 | 2019-12-21 11:32:13 |
| 18950 | 9556 | 3 | 2019-12-21 11:48:06 |
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;