Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,901–17,925 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17901 | 9234 | 2 | 2019-10-18 10:44:41 |
| 17902 | 9235 | 3 | 2019-10-18 11:41:28 |
| 17903 | 9234 | 1 | 2019-10-18 11:48:46 |
| 17904 | 9234 | 3 | 2019-10-18 12:17:35 |
| 17905 | 9155 | 2 | 2019-10-18 17:03:38 |
| 17906 | 9154 | 2 | 2019-10-18 17:04:40 |
| 17907 | 9240 | 1 | 2019-10-19 10:50:58 |
| 17908 | 9239 | 1 | 2019-10-19 10:55:36 |
| 17909 | 9240 | 2 | 2019-10-19 12:05:37 |
| 17910 | 9159 | 2 | 2019-10-19 14:43:59 |
| 17911 | 9158 | 2 | 2019-10-19 14:44:52 |
| 17912 | 9156 | 2 | 2019-10-19 14:45:59 |
| 17913 | 9157 | 2 | 2019-10-19 14:48:20 |
| 17914 | 9144 | 2 | 2019-10-20 12:12:58 |
| 17915 | 9144 | 1 | 2019-10-20 13:15:23 |
| 17916 | 9144 | 3 | 2019-10-20 13:55:37 |
| 17917 | 9295 | 2 | 2019-10-22 11:48:48 |
| 17918 | 9295 | 1 | 2019-10-22 12:33:35 |
| 17919 | 9295 | 3 | 2019-10-22 13:57:53 |
| 17920 | 9298 | 2 | 2019-10-23 09:53:39 |
| 17921 | 9299 | 3 | 2019-10-23 10:05:08 |
| 17922 | 9299 | 2 | 2019-10-23 11:04:45 |
| 17923 | 9232 | 2 | 2019-10-23 11:06:26 |
| 17924 | 9230 | 2 | 2019-10-23 11:09:23 |
| 17925 | 9231 | 3 | 2019-10-23 11:14:24 |
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;