Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,326–2,350 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2326 | 1318 | 3 | 2015-10-14 12:40:07 |
| 2327 | 1317 | 3 | 2015-10-14 13:09:51 |
| 2328 | 1318 | 2 | 2015-10-14 14:04:10 |
| 2329 | 1317 | 1 | 2015-10-14 14:06:52 |
| 2330 | 1324 | 1 | 2015-10-15 09:45:50 |
| 2331 | 1325 | 2 | 2015-10-15 12:12:18 |
| 2332 | 1325 | 3 | 2015-10-15 12:49:50 |
| 2333 | 1325 | 2 | 2015-10-15 14:07:51 |
| 2334 | 1325 | 1 | 2015-10-15 14:45:55 |
| 2335 | 1327 | 1 | 2015-10-16 11:17:54 |
| 2336 | 1326 | 1 | 2015-10-16 11:25:37 |
| 2337 | 1327 | 2 | 2015-10-16 12:00:59 |
| 2338 | 1326 | 2 | 2015-10-16 12:33:58 |
| 2339 | 1320 | 1 | 2015-10-16 12:51:23 |
| 2340 | 1321 | 1 | 2015-10-16 13:00:16 |
| 2341 | 1320 | 2 | 2015-10-16 13:55:54 |
| 2342 | 1321 | 2 | 2015-10-16 14:17:55 |
| 2343 | 1295 | 2 | 2015-10-17 11:49:24 |
| 2344 | 1296 | 2 | 2015-10-17 11:50:59 |
| 2345 | 1331 | 3 | 2015-10-18 11:15:34 |
| 2346 | 1335 | 2 | 2015-10-18 13:51:08 |
| 2347 | 1332 | 2 | 2015-10-18 13:56:36 |
| 2348 | 1333 | 2 | 2015-10-18 13:56:38 |
| 2349 | 1334 | 3 | 2015-10-18 14:06:18 |
| 2350 | 1333 | 1 | 2015-10-18 14:35:42 |
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;