Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,201–16,225 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16201 | 8026 | 2 | 2019-05-31 12:22:34 |
| 16202 | 8014 | 2 | 2019-05-31 12:22:58 |
| 16203 | 8266 | 2 | 2019-05-31 12:23:32 |
| 16204 | 8019 | 2 | 2019-05-31 12:23:47 |
| 16205 | 8023 | 2 | 2019-05-31 12:24:18 |
| 16206 | 8006 | 1 | 2019-05-31 12:35:53 |
| 16207 | 8003 | 1 | 2019-05-31 12:37:06 |
| 16208 | 8021 | 1 | 2019-05-31 12:41:46 |
| 16209 | 8017 | 1 | 2019-05-31 12:43:58 |
| 16210 | 8015 | 1 | 2019-05-31 12:45:13 |
| 16211 | 8005 | 1 | 2019-05-31 12:49:08 |
| 16212 | 8032 | 1 | 2019-05-31 12:50:08 |
| 16213 | 8004 | 1 | 2019-05-31 12:57:27 |
| 16214 | 8279 | 2 | 2019-05-31 12:58:22 |
| 16215 | 8212 | 3 | 2019-05-31 13:00:14 |
| 16216 | 7997 | 1 | 2019-05-31 13:00:37 |
| 16217 | 8028 | 1 | 2019-05-31 13:06:51 |
| 16218 | 8001 | 1 | 2019-05-31 13:07:12 |
| 16219 | 7998 | 1 | 2019-05-31 13:07:24 |
| 16220 | 8034 | 1 | 2019-05-31 13:07:36 |
| 16221 | 8278 | 2 | 2019-05-31 13:11:46 |
| 16222 | 8211 | 3 | 2019-05-31 13:12:15 |
| 16223 | 8030 | 1 | 2019-05-31 13:12:38 |
| 16224 | 8005 | 2 | 2019-05-31 13:18:07 |
| 16225 | 8018 | 1 | 2019-05-31 13:18:24 |
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;