Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,701–10,725 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10701 | 5515 | 2 | 2018-04-10 15:48:42 |
| 10702 | 5539 | 2 | 2018-04-10 16:18:59 |
| 10703 | 5502 | 2 | 2018-04-11 10:01:19 |
| 10704 | 5503 | 2 | 2018-04-11 10:10:09 |
| 10705 | 5503 | 1 | 2018-04-11 10:46:01 |
| 10706 | 5502 | 1 | 2018-04-11 10:55:57 |
| 10707 | 5540 | 2 | 2018-04-11 13:38:53 |
| 10708 | 5542 | 2 | 2018-04-11 13:41:18 |
| 10709 | 5541 | 2 | 2018-04-11 13:41:51 |
| 10710 | 5543 | 2 | 2018-04-11 13:45:52 |
| 10711 | 5542 | 3 | 2018-04-11 14:42:32 |
| 10712 | 5540 | 1 | 2018-04-11 15:09:46 |
| 10713 | 5542 | 1 | 2018-04-11 15:22:54 |
| 10714 | 5542 | 2 | 2018-04-11 16:38:03 |
| 10715 | 5552 | 3 | 2018-04-12 11:02:41 |
| 10716 | 5553 | 3 | 2018-04-12 11:06:29 |
| 10717 | 5554 | 2 | 2018-04-12 11:09:17 |
| 10718 | 5552 | 2 | 2018-04-12 11:55:20 |
| 10719 | 5553 | 2 | 2018-04-12 12:05:17 |
| 10720 | 5554 | 3 | 2018-04-12 12:38:53 |
| 10721 | 5555 | 1 | 2018-04-12 14:19:24 |
| 10722 | 5556 | 1 | 2018-04-12 14:23:17 |
| 10723 | 5556 | 3 | 2018-04-12 14:57:18 |
| 10724 | 5555 | 3 | 2018-04-12 14:59:02 |
| 10725 | 5337 | 2 | 2018-04-12 15:16:02 |
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;