Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,851–13,875 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13851 | 7004 | 2 | 2018-11-21 15:59:32 |
| 13852 | 7153 | 2 | 2018-11-22 11:07:30 |
| 13853 | 7150 | 2 | 2018-11-22 11:11:49 |
| 13854 | 7151 | 2 | 2018-11-22 11:14:45 |
| 13855 | 7152 | 3 | 2018-11-22 11:19:35 |
| 13856 | 7151 | 3 | 2018-11-22 11:48:56 |
| 13857 | 7150 | 3 | 2018-11-22 12:04:14 |
| 13858 | 7153 | 3 | 2018-11-22 12:19:36 |
| 13859 | 7152 | 1 | 2018-11-22 12:37:59 |
| 13860 | 7150 | 2 | 2018-11-22 13:01:09 |
| 13861 | 7151 | 2 | 2018-11-22 13:03:01 |
| 13862 | 7153 | 2 | 2018-11-22 13:32:20 |
| 13863 | 7152 | 2 | 2018-11-22 14:08:51 |
| 13864 | 7083 | 2 | 2018-11-23 11:26:01 |
| 13865 | 7083 | 3 | 2018-11-23 12:40:30 |
| 13866 | 7171 | 3 | 2018-11-23 14:11:13 |
| 13867 | 7175 | 3 | 2018-11-23 15:03:04 |
| 13868 | 7172 | 3 | 2018-11-23 15:05:06 |
| 13869 | 7173 | 1 | 2018-11-23 15:07:24 |
| 13870 | 7174 | 3 | 2018-11-23 15:10:35 |
| 13871 | 7171 | 2 | 2018-11-23 15:33:20 |
| 13872 | 7171 | 1 | 2018-11-23 16:07:06 |
| 13873 | 7173 | 2 | 2018-11-23 16:08:09 |
| 13874 | 7171 | 2 | 2018-11-23 17:13:17 |
| 13875 | 7181 | 2 | 2018-11-24 10:25:53 |
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;