Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,751–17,775 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17751 | 9123 | 1 | 2019-10-03 10:11:08 |
| 17752 | 9105 | 2 | 2019-10-03 10:19:34 |
| 17753 | 9104 | 2 | 2019-10-03 10:36:10 |
| 17754 | 9020 | 2 | 2019-10-03 10:37:13 |
| 17755 | 9106 | 1 | 2019-10-03 10:46:21 |
| 17756 | 9134 | 2 | 2019-10-03 11:06:36 |
| 17757 | 9022 | 2 | 2019-10-03 11:06:55 |
| 17758 | 9133 | 2 | 2019-10-03 11:12:21 |
| 17759 | 9106 | 3 | 2019-10-03 11:14:53 |
| 17760 | 9021 | 2 | 2019-10-03 11:28:04 |
| 17761 | 9019 | 2 | 2019-10-03 11:29:25 |
| 17762 | 9022 | 3 | 2019-10-03 11:37:45 |
| 17763 | 9105 | 3 | 2019-10-03 11:42:38 |
| 17764 | 9020 | 3 | 2019-10-03 11:52:10 |
| 17765 | 9104 | 3 | 2019-10-03 12:10:54 |
| 17766 | 9134 | 1 | 2019-10-03 12:23:18 |
| 17767 | 9133 | 1 | 2019-10-03 12:46:49 |
| 17768 | 9019 | 3 | 2019-10-03 12:47:57 |
| 17769 | 9021 | 3 | 2019-10-03 12:50:13 |
| 17770 | 9094 | 2 | 2019-10-04 11:04:10 |
| 17771 | 9095 | 2 | 2019-10-04 11:06:38 |
| 17772 | 9116 | 2 | 2019-10-05 10:06:06 |
| 17773 | 9116 | 3 | 2019-10-05 11:37:20 |
| 17774 | 9116 | 1 | 2019-10-05 12:39:52 |
| 17775 | 9131 | 2 | 2019-10-05 13:55:27 |
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;