Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,551–2,575 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2551 | 1161 | 3 | 2015-11-10 12:37:15 |
| 2552 | 1172 | 1 | 2015-11-10 12:38:13 |
| 2553 | 1135 | 1 | 2015-11-10 12:39:28 |
| 2554 | 1154 | 1 | 2015-11-10 12:41:14 |
| 2555 | 1145 | 1 | 2015-11-10 12:41:22 |
| 2556 | 1147 | 1 | 2015-11-10 12:42:17 |
| 2557 | 1163 | 3 | 2015-11-10 12:46:00 |
| 2558 | 1160 | 1 | 2015-11-10 12:49:06 |
| 2559 | 1139 | 3 | 2015-11-10 12:51:08 |
| 2560 | 1164 | 1 | 2015-11-10 12:51:44 |
| 2561 | 1162 | 3 | 2015-11-10 12:52:50 |
| 2562 | 1173 | 3 | 2015-11-10 12:52:50 |
| 2563 | 1142 | 3 | 2015-11-10 12:59:04 |
| 2564 | 1137 | 1 | 2015-11-10 12:59:35 |
| 2565 | 1174 | 3 | 2015-11-10 13:01:32 |
| 2566 | 1144 | 1 | 2015-11-10 13:01:52 |
| 2567 | 1134 | 3 | 2015-11-10 13:02:02 |
| 2568 | 1146 | 3 | 2015-11-10 13:02:48 |
| 2569 | 1158 | 1 | 2015-11-10 13:06:15 |
| 2570 | 1136 | 3 | 2015-11-10 13:06:47 |
| 2571 | 1152 | 3 | 2015-11-10 13:09:27 |
| 2572 | 1140 | 3 | 2015-11-10 13:09:51 |
| 2573 | 1169 | 3 | 2015-11-10 13:10:33 |
| 2574 | 1157 | 3 | 2015-11-10 13:12:19 |
| 2575 | 1167 | 3 | 2015-11-10 13:15: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;