Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,801–2,825 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2801 | 1409 | 3 | 2015-12-07 12:23:38 |
| 2802 | 1394 | 3 | 2015-12-07 12:23:52 |
| 2803 | 1403 | 3 | 2015-12-07 12:24:14 |
| 2804 | 1411 | 3 | 2015-12-07 12:24:40 |
| 2805 | 1386 | 3 | 2015-12-07 12:25:03 |
| 2806 | 1387 | 3 | 2015-12-07 12:25:09 |
| 2807 | 1375 | 3 | 2015-12-07 12:25:19 |
| 2808 | 1385 | 3 | 2015-12-07 12:25:34 |
| 2809 | 1391 | 3 | 2015-12-07 12:26:23 |
| 2810 | 1396 | 3 | 2015-12-07 12:27:43 |
| 2811 | 1381 | 3 | 2015-12-07 12:27:51 |
| 2812 | 1395 | 3 | 2015-12-07 12:27:53 |
| 2813 | 1414 | 3 | 2015-12-07 12:27:53 |
| 2814 | 1398 | 3 | 2015-12-07 12:28:05 |
| 2815 | 1404 | 3 | 2015-12-07 12:28:54 |
| 2816 | 1383 | 3 | 2015-12-07 12:29:09 |
| 2817 | 1406 | 3 | 2015-12-07 12:29:29 |
| 2818 | 1376 | 3 | 2015-12-07 12:29:42 |
| 2819 | 1374 | 3 | 2015-12-07 12:29:44 |
| 2820 | 1392 | 3 | 2015-12-07 12:29:54 |
| 2821 | 1389 | 3 | 2015-12-07 12:29:59 |
| 2822 | 1415 | 3 | 2015-12-07 12:30:17 |
| 2823 | 1413 | 3 | 2015-12-07 12:30:28 |
| 2824 | 1393 | 3 | 2015-12-07 12:30:38 |
| 2825 | 1412 | 3 | 2015-12-07 12:31:19 |
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;