Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,226–8,250 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8226 | 4276 | 2 | 2017-07-18 09:54:15 |
| 8227 | 4272 | 2 | 2017-07-18 09:55:32 |
| 8228 | 4273 | 2 | 2017-07-18 09:59:02 |
| 8229 | 4274 | 2 | 2017-07-18 10:00:59 |
| 8230 | 4275 | 2 | 2017-07-18 10:06:56 |
| 8231 | 4274 | 3 | 2017-07-18 10:27:24 |
| 8232 | 4276 | 3 | 2017-07-18 10:28:13 |
| 8233 | 4273 | 3 | 2017-07-18 11:02:49 |
| 8234 | 4275 | 3 | 2017-07-18 11:12:46 |
| 8235 | 4164 | 2 | 2017-07-18 11:18:03 |
| 8236 | 4272 | 3 | 2017-07-18 11:21:20 |
| 8237 | 4164 | 3 | 2017-07-18 11:45:40 |
| 8238 | 4276 | 1 | 2017-07-18 11:46:10 |
| 8239 | 4274 | 1 | 2017-07-18 11:49:03 |
| 8240 | 4273 | 1 | 2017-07-18 12:00:02 |
| 8241 | 4277 | 2 | 2017-07-18 12:01:15 |
| 8242 | 4275 | 1 | 2017-07-18 12:18:23 |
| 8243 | 4272 | 1 | 2017-07-18 12:21:29 |
| 8244 | 4273 | 2 | 2017-07-18 12:37:28 |
| 8245 | 4276 | 2 | 2017-07-18 12:48:11 |
| 8246 | 4277 | 1 | 2017-07-18 12:52:14 |
| 8247 | 4164 | 1 | 2017-07-18 12:54:07 |
| 8248 | 4274 | 2 | 2017-07-18 13:12:26 |
| 8249 | 4164 | 2 | 2017-07-18 13:37:15 |
| 8250 | 4272 | 2 | 2017-07-18 13:42:25 |
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;