Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,926–16,950 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16926 | 8570 | 3 | 2019-07-19 15:15:52 |
| 16927 | 8553 | 1 | 2019-07-19 15:33:46 |
| 16928 | 8571 | 3 | 2019-07-19 16:20:34 |
| 16929 | 8572 | 3 | 2019-07-19 16:24:40 |
| 16930 | 8570 | 1 | 2019-07-19 16:30:47 |
| 16931 | 8577 | 2 | 2019-07-20 10:13:07 |
| 16932 | 8579 | 3 | 2019-07-20 10:13:50 |
| 16933 | 8576 | 2 | 2019-07-20 10:13:53 |
| 16934 | 8578 | 2 | 2019-07-20 10:15:46 |
| 16935 | 8549 | 1 | 2019-07-20 10:55:58 |
| 16936 | 8576 | 3 | 2019-07-20 11:04:32 |
| 16937 | 8577 | 3 | 2019-07-20 11:32:50 |
| 16938 | 8578 | 3 | 2019-07-20 11:40:05 |
| 16939 | 8549 | 2 | 2019-07-20 12:01:36 |
| 16940 | 8580 | 1 | 2019-07-20 12:34:37 |
| 16941 | 8581 | 1 | 2019-07-20 12:34:55 |
| 16942 | 8581 | 3 | 2019-07-20 13:05:04 |
| 16943 | 8564 | 1 | 2019-07-20 13:57:57 |
| 16944 | 8561 | 1 | 2019-07-20 13:58:10 |
| 16945 | 8580 | 3 | 2019-07-20 14:03:11 |
| 16946 | 8563 | 1 | 2019-07-20 14:06:24 |
| 16947 | 8562 | 1 | 2019-07-20 14:08:50 |
| 16948 | 8563 | 3 | 2019-07-20 14:36:39 |
| 16949 | 8582 | 3 | 2019-07-20 14:56:21 |
| 16950 | 8564 | 3 | 2019-07-20 14:57:15 |
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;