Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,451–2,475 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2451 | 1149 | 1 | 2015-11-10 10:04:06 |
| 2452 | 1155 | 1 | 2015-11-10 10:05:42 |
| 2453 | 1157 | 1 | 2015-11-10 10:05:49 |
| 2454 | 1139 | 1 | 2015-11-10 10:05:50 |
| 2455 | 1147 | 1 | 2015-11-10 10:08:05 |
| 2456 | 1170 | 1 | 2015-11-10 10:08:13 |
| 2457 | 1143 | 1 | 2015-11-10 10:08:42 |
| 2458 | 1151 | 1 | 2015-11-10 10:09:32 |
| 2459 | 1174 | 1 | 2015-11-10 10:10:16 |
| 2460 | 1156 | 1 | 2015-11-10 10:11:18 |
| 2461 | 1165 | 1 | 2015-11-10 10:11:42 |
| 2462 | 1163 | 1 | 2015-11-10 10:12:38 |
| 2463 | 1166 | 1 | 2015-11-10 10:12:59 |
| 2464 | 1146 | 1 | 2015-11-10 10:13:01 |
| 2465 | 1148 | 1 | 2015-11-10 10:13:12 |
| 2466 | 1150 | 1 | 2015-11-10 10:13:38 |
| 2467 | 1173 | 1 | 2015-11-10 10:13:58 |
| 2468 | 1137 | 1 | 2015-11-10 10:14:03 |
| 2469 | 1140 | 1 | 2015-11-10 10:14:15 |
| 2470 | 1171 | 1 | 2015-11-10 10:14:29 |
| 2471 | 1145 | 1 | 2015-11-10 10:15:21 |
| 2472 | 1164 | 1 | 2015-11-10 10:16:11 |
| 2473 | 1172 | 1 | 2015-11-10 10:16:20 |
| 2474 | 1161 | 1 | 2015-11-10 10:17:53 |
| 2475 | 1158 | 1 | 2015-11-10 10:17:55 |
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;