Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,501–15,525 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15501 | 8036 | 3 | 2019-04-08 13:19:07 |
| 15502 | 7995 | 1 | 2019-04-08 13:25:29 |
| 15503 | 8036 | 2 | 2019-04-08 14:32:20 |
| 15504 | 8036 | 3 | 2019-04-08 15:09:42 |
| 15505 | 8038 | 1 | 2019-04-09 12:18:41 |
| 15506 | 8040 | 1 | 2019-04-09 12:21:44 |
| 15507 | 8039 | 1 | 2019-04-09 12:23:43 |
| 15508 | 8038 | 3 | 2019-04-09 12:57:56 |
| 15509 | 8039 | 3 | 2019-04-09 13:22:43 |
| 15510 | 8040 | 3 | 2019-04-09 13:23:52 |
| 15511 | 8038 | 2 | 2019-04-09 13:51:23 |
| 15512 | 8040 | 2 | 2019-04-09 14:08:01 |
| 15513 | 8039 | 2 | 2019-04-09 14:37:21 |
| 15514 | 8042 | 1 | 2019-04-09 15:55:38 |
| 15515 | 8041 | 1 | 2019-04-09 16:03:16 |
| 15516 | 7616 | 2 | 2019-04-10 14:22:17 |
| 15517 | 7616 | 1 | 2019-04-10 15:17:07 |
| 15518 | 7616 | 3 | 2019-04-10 16:19:28 |
| 15519 | 8045 | 2 | 2019-04-11 10:32:31 |
| 15520 | 8045 | 1 | 2019-04-11 11:06:50 |
| 15521 | 7977 | 2 | 2019-04-11 12:07:50 |
| 15522 | 7976 | 2 | 2019-04-11 12:13:06 |
| 15523 | 7975 | 1 | 2019-04-11 12:14:10 |
| 15524 | 7976 | 1 | 2019-04-11 13:27:47 |
| 15525 | 7822 | 2 | 2019-04-11 13:27:58 |
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;