Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,001–4,025 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4001 | 2074 | 3 | 2016-04-22 12:28:13 |
| 4002 | 2075 | 1 | 2016-04-22 12:45:17 |
| 4003 | 2079 | 3 | 2016-04-24 10:23:29 |
| 4004 | 2080 | 3 | 2016-04-24 10:24:37 |
| 4005 | 2082 | 3 | 2016-04-24 10:27:18 |
| 4006 | 2047 | 2 | 2016-04-25 11:38:54 |
| 4007 | 2047 | 1 | 2016-04-25 12:20:44 |
| 4008 | 2047 | 2 | 2016-04-25 13:33:01 |
| 4009 | 2047 | 3 | 2016-04-25 14:08:09 |
| 4010 | 2087 | 3 | 2016-04-26 09:16:40 |
| 4011 | 2088 | 3 | 2016-04-26 09:28:00 |
| 4012 | 2088 | 2 | 2016-04-26 09:56:35 |
| 4013 | 2087 | 2 | 2016-04-26 10:47:47 |
| 4014 | 2087 | 3 | 2016-04-26 11:14:29 |
| 4015 | 2088 | 3 | 2016-04-26 11:14:36 |
| 4016 | 2054 | 2 | 2016-04-26 11:15:55 |
| 4017 | 2055 | 2 | 2016-04-26 11:17:59 |
| 4018 | 2056 | 2 | 2016-04-26 11:20:52 |
| 4019 | 2053 | 2 | 2016-04-26 11:22:35 |
| 4020 | 2087 | 1 | 2016-04-26 11:47:21 |
| 4021 | 2088 | 1 | 2016-04-26 11:56:05 |
| 4022 | 2055 | 3 | 2016-04-26 12:38:33 |
| 4023 | 2056 | 3 | 2016-04-26 12:42:04 |
| 4024 | 2054 | 3 | 2016-04-26 12:51:01 |
| 4025 | 2053 | 3 | 2016-04-26 12:54: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;