Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,676–13,700 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13676 | 6931 | 2 | 2018-11-02 10:28:07 |
| 13677 | 6934 | 3 | 2018-11-02 10:38:32 |
| 13678 | 6933 | 1 | 2018-11-02 11:57:35 |
| 13679 | 6934 | 1 | 2018-11-02 12:02:47 |
| 13680 | 6892 | 2 | 2018-11-02 14:02:27 |
| 13681 | 6893 | 1 | 2018-11-02 14:13:31 |
| 13682 | 6893 | 3 | 2018-11-02 15:14:34 |
| 13683 | 6893 | 2 | 2018-11-02 15:56:35 |
| 13684 | 7003 | 2 | 2018-11-03 09:19:07 |
| 13685 | 7017 | 2 | 2018-11-04 10:45:47 |
| 13686 | 7017 | 3 | 2018-11-04 11:12:28 |
| 13687 | 7017 | 2 | 2018-11-04 12:45:39 |
| 13688 | 7020 | 3 | 2018-11-05 13:04:41 |
| 13689 | 7019 | 2 | 2018-11-05 13:10:03 |
| 13690 | 7021 | 3 | 2018-11-05 13:12:44 |
| 13691 | 7020 | 2 | 2018-11-05 13:30:34 |
| 13692 | 7021 | 2 | 2018-11-05 14:12:08 |
| 13693 | 7023 | 2 | 2018-11-05 14:31:06 |
| 13694 | 7019 | 3 | 2018-11-05 14:35:07 |
| 13695 | 7022 | 2 | 2018-11-05 14:40:00 |
| 13696 | 7023 | 1 | 2018-11-05 15:31:14 |
| 13697 | 7023 | 2 | 2018-11-05 16:10:33 |
| 13698 | 7022 | 1 | 2018-11-05 16:13:45 |
| 13699 | 7022 | 2 | 2018-11-05 17:29:32 |
| 13700 | 7024 | 1 | 2018-11-06 13:17:06 |
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;