Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,151–8,175 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8151 | 4183 | 2 | 2017-07-08 13:51:51 |
| 8152 | 4188 | 3 | 2017-07-08 14:28:09 |
| 8153 | 4182 | 3 | 2017-07-08 15:13:40 |
| 8154 | 4182 | 2 | 2017-07-08 16:25:34 |
| 8155 | 4180 | 3 | 2017-07-09 09:25:48 |
| 8156 | 4180 | 1 | 2017-07-09 10:21:46 |
| 8157 | 4194 | 2 | 2017-07-09 14:03:45 |
| 8158 | 4193 | 2 | 2017-07-09 14:04:39 |
| 8159 | 4195 | 2 | 2017-07-09 14:16:24 |
| 8160 | 4193 | 3 | 2017-07-09 15:01:46 |
| 8161 | 4244 | 2 | 2017-07-11 12:04:29 |
| 8162 | 4243 | 2 | 2017-07-11 12:08:32 |
| 8163 | 4243 | 3 | 2017-07-11 12:37:30 |
| 8164 | 4244 | 3 | 2017-07-11 13:31:44 |
| 8165 | 4243 | 2 | 2017-07-11 13:49:06 |
| 8166 | 4244 | 2 | 2017-07-11 13:58:59 |
| 8167 | 4100 | 2 | 2017-07-12 10:49:01 |
| 8168 | 4099 | 2 | 2017-07-12 10:52:47 |
| 8169 | 4100 | 3 | 2017-07-12 11:42:59 |
| 8170 | 4099 | 3 | 2017-07-12 11:46:55 |
| 8171 | 4172 | 1 | 2017-07-12 12:10:40 |
| 8172 | 4173 | 1 | 2017-07-12 12:12:46 |
| 8173 | 4099 | 2 | 2017-07-12 12:36:38 |
| 8174 | 4173 | 3 | 2017-07-12 13:09:38 |
| 8175 | 4100 | 2 | 2017-07-12 13:11:46 |
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;