Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,851–2,875 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2851 | 1402 | 1 | 2015-12-07 13:15:19 |
| 2852 | 1405 | 1 | 2015-12-07 13:17:50 |
| 2853 | 1566 | 1 | 2015-12-07 13:18:18 |
| 2854 | 1397 | 1 | 2015-12-07 13:18:41 |
| 2855 | 1411 | 1 | 2015-12-07 13:19:36 |
| 2856 | 1403 | 1 | 2015-12-07 13:25:18 |
| 2857 | 1383 | 1 | 2015-12-07 13:27:58 |
| 2858 | 1404 | 1 | 2015-12-07 13:28:38 |
| 2859 | 1376 | 1 | 2015-12-07 13:29:25 |
| 2860 | 1375 | 1 | 2015-12-07 13:30:17 |
| 2861 | 1415 | 1 | 2015-12-07 13:31:34 |
| 2862 | 1398 | 1 | 2015-12-07 13:36:59 |
| 2863 | 1384 | 1 | 2015-12-07 13:37:21 |
| 2864 | 1412 | 1 | 2015-12-07 13:37:31 |
| 2865 | 1400 | 1 | 2015-12-07 13:40:44 |
| 2866 | 1410 | 1 | 2015-12-07 13:41:02 |
| 2867 | 1378 | 1 | 2015-12-07 13:42:10 |
| 2868 | 1387 | 1 | 2015-12-07 13:43:05 |
| 2869 | 1408 | 1 | 2015-12-07 13:45:00 |
| 2870 | 1382 | 1 | 2015-12-07 13:45:37 |
| 2871 | 1406 | 1 | 2015-12-07 13:45:42 |
| 2872 | 1386 | 1 | 2015-12-07 13:46:03 |
| 2873 | 1407 | 1 | 2015-12-07 13:46:58 |
| 2874 | 1396 | 1 | 2015-12-07 13:48:30 |
| 2875 | 1413 | 1 | 2015-12-07 13:54:36 |
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;