Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,026–8,050 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8026 | 4155 | 2 | 2017-07-01 09:44:12 |
| 8027 | 4044 | 2 | 2017-07-01 11:20:12 |
| 8028 | 4045 | 2 | 2017-07-01 11:21:52 |
| 8029 | 4046 | 2 | 2017-07-01 11:23:35 |
| 8030 | 4159 | 3 | 2017-07-01 12:51:47 |
| 8031 | 4151 | 2 | 2017-07-01 13:03:17 |
| 8032 | 4152 | 2 | 2017-07-01 13:03:26 |
| 8033 | 4158 | 3 | 2017-07-01 13:03:44 |
| 8034 | 4153 | 2 | 2017-07-01 13:09:34 |
| 8035 | 4150 | 2 | 2017-07-01 13:14:09 |
| 8036 | 4153 | 1 | 2017-07-01 13:40:23 |
| 8037 | 4150 | 1 | 2017-07-01 13:49:11 |
| 8038 | 4151 | 1 | 2017-07-01 14:10:37 |
| 8039 | 4159 | 1 | 2017-07-01 14:24:27 |
| 8040 | 4153 | 3 | 2017-07-01 14:27:54 |
| 8041 | 4152 | 1 | 2017-07-01 14:28:49 |
| 8042 | 4158 | 1 | 2017-07-01 14:38:00 |
| 8043 | 4150 | 3 | 2017-07-01 15:19:55 |
| 8044 | 4162 | 1 | 2017-07-01 15:40:56 |
| 8045 | 4163 | 2 | 2017-07-01 15:42:34 |
| 8046 | 4151 | 3 | 2017-07-01 15:45:38 |
| 8047 | 4160 | 2 | 2017-07-01 15:47:16 |
| 8048 | 4161 | 2 | 2017-07-01 15:50:38 |
| 8049 | 4162 | 2 | 2017-07-01 16:46:26 |
| 8050 | 3641 | 3 | 2017-07-02 10:10:09 |
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;