Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,276–4,300 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4276 | 2254 | 1 | 2016-05-28 12:10:01 |
| 4277 | 2254 | 3 | 2016-05-28 13:40:38 |
| 4278 | 2298 | 2 | 2016-05-28 15:20:29 |
| 4279 | 2299 | 2 | 2016-05-28 15:31:41 |
| 4280 | 2151 | 3 | 2016-05-29 12:11:17 |
| 4281 | 2146 | 3 | 2016-05-29 12:11:47 |
| 4282 | 2152 | 3 | 2016-05-29 12:12:13 |
| 4283 | 2158 | 3 | 2016-05-29 12:13:09 |
| 4284 | 2175 | 3 | 2016-05-29 12:13:14 |
| 4285 | 2167 | 3 | 2016-05-29 12:14:07 |
| 4286 | 2157 | 3 | 2016-05-29 12:14:24 |
| 4287 | 2163 | 3 | 2016-05-29 12:15:07 |
| 4288 | 2150 | 3 | 2016-05-29 12:15:15 |
| 4289 | 2161 | 3 | 2016-05-29 12:15:58 |
| 4290 | 2172 | 3 | 2016-05-29 12:15:58 |
| 4291 | 2188 | 3 | 2016-05-29 12:16:06 |
| 4292 | 2192 | 3 | 2016-05-29 12:16:09 |
| 4293 | 2155 | 3 | 2016-05-29 12:16:16 |
| 4294 | 2168 | 3 | 2016-05-29 12:16:24 |
| 4295 | 2171 | 3 | 2016-05-29 12:16:57 |
| 4296 | 2162 | 3 | 2016-05-29 12:17:03 |
| 4297 | 2160 | 3 | 2016-05-29 12:18:16 |
| 4298 | 2174 | 3 | 2016-05-29 12:18:47 |
| 4299 | 2178 | 3 | 2016-05-29 12:19:08 |
| 4300 | 2184 | 3 | 2016-05-29 12:20:16 |
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;