Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,451–7,475 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7451 | 3449 | 2 | 2017-05-03 12:23:58 |
| 7452 | 3470 | 2 | 2017-05-03 12:24:58 |
| 7453 | 3452 | 2 | 2017-05-03 12:25:02 |
| 7454 | 3464 | 2 | 2017-05-03 12:25:14 |
| 7455 | 3432 | 2 | 2017-05-03 12:25:34 |
| 7456 | 3446 | 2 | 2017-05-03 12:25:36 |
| 7457 | 3456 | 2 | 2017-05-03 12:26:36 |
| 7458 | 3438 | 2 | 2017-05-03 12:27:08 |
| 7459 | 3461 | 2 | 2017-05-03 12:28:36 |
| 7460 | 3451 | 2 | 2017-05-03 12:28:58 |
| 7461 | 3465 | 2 | 2017-05-03 12:29:15 |
| 7462 | 3885 | 1 | 2017-05-04 11:34:39 |
| 7463 | 3885 | 2 | 2017-05-04 12:43:41 |
| 7464 | 3842 | 2 | 2017-05-04 14:30:29 |
| 7465 | 3842 | 3 | 2017-05-04 15:22:02 |
| 7466 | 3854 | 2 | 2017-05-04 15:50:45 |
| 7467 | 3842 | 2 | 2017-05-04 15:59:13 |
| 7468 | 3854 | 1 | 2017-05-04 16:40:09 |
| 7469 | 3875 | 3 | 2017-05-05 11:20:21 |
| 7470 | 3874 | 3 | 2017-05-05 11:20:23 |
| 7471 | 3876 | 3 | 2017-05-05 11:29:39 |
| 7472 | 3886 | 1 | 2017-05-05 11:29:39 |
| 7473 | 3873 | 1 | 2017-05-05 11:33:53 |
| 7474 | 3875 | 1 | 2017-05-05 12:00:15 |
| 7475 | 3874 | 1 | 2017-05-05 12:15:04 |
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;