Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,651–13,675 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13651 | 6907 | 1 | 2018-10-29 13:44:31 |
| 13652 | 6942 | 1 | 2018-10-29 14:03:30 |
| 13653 | 6906 | 3 | 2018-10-29 14:04:02 |
| 13654 | 6908 | 3 | 2018-10-29 14:09:15 |
| 13655 | 6943 | 1 | 2018-10-29 14:47:53 |
| 13656 | 6907 | 3 | 2018-10-29 14:52:06 |
| 13657 | 6941 | 1 | 2018-10-29 15:06:16 |
| 13658 | 6942 | 3 | 2018-10-29 15:19:40 |
| 13659 | 6943 | 3 | 2018-10-29 16:02:11 |
| 13660 | 6941 | 3 | 2018-10-29 16:19:10 |
| 13661 | 6890 | 2 | 2018-10-31 09:53:03 |
| 13662 | 6889 | 2 | 2018-10-31 10:03:31 |
| 13663 | 6890 | 3 | 2018-10-31 10:52:54 |
| 13664 | 6948 | 3 | 2018-10-31 11:09:27 |
| 13665 | 6889 | 3 | 2018-10-31 11:27:05 |
| 13666 | 6890 | 1 | 2018-10-31 11:39:28 |
| 13667 | 6896 | 2 | 2018-10-31 12:05:25 |
| 13668 | 6897 | 1 | 2018-10-31 12:08:28 |
| 13669 | 6889 | 1 | 2018-10-31 12:33:33 |
| 13670 | 6897 | 3 | 2018-10-31 12:42:30 |
| 13671 | 6948 | 1 | 2018-10-31 12:43:36 |
| 13672 | 7001 | 1 | 2018-10-31 15:34:26 |
| 13673 | 7002 | 1 | 2018-10-31 15:45:51 |
| 13674 | 6933 | 3 | 2018-11-02 10:27:16 |
| 13675 | 6932 | 2 | 2018-11-02 10:27:33 |
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;