Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,026–16,050 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16026 | 7538 | 2 | 2019-05-17 11:00:01 |
| 16027 | 7555 | 2 | 2019-05-17 11:00:34 |
| 16028 | 7573 | 2 | 2019-05-17 11:01:16 |
| 16029 | 7535 | 2 | 2019-05-17 11:01:58 |
| 16030 | 7567 | 2 | 2019-05-17 11:02:19 |
| 16031 | 7546 | 2 | 2019-05-17 11:02:41 |
| 16032 | 7560 | 2 | 2019-05-17 11:02:46 |
| 16033 | 7551 | 2 | 2019-05-17 11:02:58 |
| 16034 | 7559 | 2 | 2019-05-17 11:04:19 |
| 16035 | 7564 | 2 | 2019-05-17 11:04:45 |
| 16036 | 7568 | 2 | 2019-05-17 11:07:14 |
| 16037 | 8233 | 3 | 2019-05-17 12:12:02 |
| 16038 | 8234 | 3 | 2019-05-17 12:18:38 |
| 16039 | 8233 | 2 | 2019-05-17 13:22:32 |
| 16040 | 8234 | 2 | 2019-05-17 13:41:29 |
| 16041 | 8240 | 2 | 2019-05-17 14:46:45 |
| 16042 | 8241 | 2 | 2019-05-17 14:50:40 |
| 16043 | 8240 | 3 | 2019-05-17 15:28:10 |
| 16044 | 8241 | 3 | 2019-05-17 15:42:54 |
| 16045 | 8240 | 2 | 2019-05-17 16:54:54 |
| 16046 | 8239 | 2 | 2019-05-18 12:06:46 |
| 16047 | 8238 | 2 | 2019-05-18 12:15:17 |
| 16048 | 8239 | 3 | 2019-05-18 13:02:01 |
| 16049 | 8238 | 3 | 2019-05-18 13:23:03 |
| 16050 | 8239 | 2 | 2019-05-18 14:08:16 |
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;