Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,451–15,475 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15451 | 7973 | 3 | 2019-04-03 16:03:25 |
| 15452 | 7974 | 1 | 2019-04-03 16:17:02 |
| 15453 | 7973 | 2 | 2019-04-03 16:28:54 |
| 15454 | 7974 | 3 | 2019-04-03 16:55:48 |
| 15455 | 7803 | 2 | 2019-04-04 09:54:55 |
| 15456 | 7928 | 3 | 2019-04-04 11:51:38 |
| 15457 | 7929 | 2 | 2019-04-04 11:58:41 |
| 15458 | 7927 | 2 | 2019-04-04 12:00:37 |
| 15459 | 7926 | 2 | 2019-04-04 12:03:44 |
| 15460 | 7926 | 3 | 2019-04-04 12:55:08 |
| 15461 | 7927 | 3 | 2019-04-04 13:03:02 |
| 15462 | 7929 | 3 | 2019-04-04 13:23:33 |
| 15463 | 7646 | 2 | 2019-04-05 11:14:04 |
| 15464 | 7648 | 2 | 2019-04-05 11:14:29 |
| 15465 | 7647 | 2 | 2019-04-05 11:14:42 |
| 15466 | 7650 | 3 | 2019-04-05 11:18:11 |
| 15467 | 7649 | 2 | 2019-04-05 11:23:26 |
| 15468 | 7647 | 1 | 2019-04-05 11:55:34 |
| 15469 | 7649 | 1 | 2019-04-05 12:04:33 |
| 15470 | 7646 | 1 | 2019-04-05 12:08:56 |
| 15471 | 7648 | 1 | 2019-04-05 12:44:30 |
| 15472 | 7650 | 2 | 2019-04-05 12:44:59 |
| 15473 | 7987 | 2 | 2019-04-06 09:23:06 |
| 15474 | 7986 | 1 | 2019-04-06 09:35:22 |
| 15475 | 7988 | 3 | 2019-04-06 09:48:00 |
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;