Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,476–2,500 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2476 | 1162 | 1 | 2015-11-10 10:19:05 |
| 2477 | 1167 | 1 | 2015-11-10 10:19:25 |
| 2478 | 1169 | 1 | 2015-11-10 10:19:58 |
| 2479 | 1134 | 3 | 2015-11-10 10:26:30 |
| 2480 | 1153 | 3 | 2015-11-10 10:28:30 |
| 2481 | 1157 | 3 | 2015-11-10 10:31:23 |
| 2482 | 1148 | 3 | 2015-11-10 10:39:09 |
| 2483 | 1146 | 3 | 2015-11-10 10:41:15 |
| 2484 | 1166 | 3 | 2015-11-10 10:42:27 |
| 2485 | 1149 | 3 | 2015-11-10 10:44:31 |
| 2486 | 1139 | 3 | 2015-11-10 10:47:14 |
| 2487 | 1171 | 3 | 2015-11-10 10:47:20 |
| 2488 | 1165 | 3 | 2015-11-10 10:47:39 |
| 2489 | 1141 | 3 | 2015-11-10 10:55:21 |
| 2490 | 1153 | 1 | 2015-11-10 10:56:41 |
| 2491 | 1156 | 3 | 2015-11-10 10:57:54 |
| 2492 | 1173 | 3 | 2015-11-10 10:59:57 |
| 2493 | 1161 | 3 | 2015-11-10 11:00:09 |
| 2494 | 1142 | 3 | 2015-11-10 11:00:10 |
| 2495 | 1163 | 3 | 2015-11-10 11:00:19 |
| 2496 | 1151 | 3 | 2015-11-10 11:00:22 |
| 2497 | 1143 | 3 | 2015-11-10 11:01:34 |
| 2498 | 1172 | 3 | 2015-11-10 11:03:34 |
| 2499 | 1167 | 3 | 2015-11-10 11:06:05 |
| 2500 | 1148 | 1 | 2015-11-10 11:09:18 |
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;