Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,301–18,325 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18301 | 9306 | 3 | 2019-11-13 16:04:28 |
| 18302 | 9395 | 2 | 2019-11-14 09:58:28 |
| 18303 | 9362 | 2 | 2019-11-14 10:51:08 |
| 18304 | 9362 | 1 | 2019-11-14 11:38:55 |
| 18305 | 9362 | 2 | 2019-11-14 12:52:41 |
| 18306 | 9382 | 1 | 2019-11-14 14:29:44 |
| 18307 | 9380 | 2 | 2019-11-15 11:04:02 |
| 18308 | 9379 | 2 | 2019-11-15 11:13:09 |
| 18309 | 9379 | 3 | 2019-11-15 12:05:23 |
| 18310 | 9380 | 3 | 2019-11-15 12:21:35 |
| 18311 | 9413 | 1 | 2019-11-15 15:41:33 |
| 18312 | 9413 | 3 | 2019-11-15 16:09:53 |
| 18313 | 9406 | 1 | 2019-11-16 09:40:15 |
| 18314 | 9407 | 2 | 2019-11-16 09:42:08 |
| 18315 | 9405 | 2 | 2019-11-16 09:51:06 |
| 18316 | 9404 | 2 | 2019-11-16 09:51:08 |
| 18317 | 9404 | 3 | 2019-11-16 10:17:37 |
| 18318 | 9407 | 3 | 2019-11-16 10:20:16 |
| 18319 | 9405 | 3 | 2019-11-16 10:39:52 |
| 18320 | 9404 | 1 | 2019-11-16 10:44:35 |
| 18321 | 9406 | 3 | 2019-11-16 11:14:51 |
| 18322 | 9405 | 1 | 2019-11-16 11:30:35 |
| 18323 | 9407 | 1 | 2019-11-16 11:51:05 |
| 18324 | 9406 | 2 | 2019-11-16 12:38:45 |
| 18325 | 9365 | 2 | 2019-11-16 13:15:14 |
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;