Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,426–2,450 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2426 | 1416 | 2 | 2015-11-06 15:47:52 |
| 2427 | 1416 | 3 | 2015-11-06 16:58:11 |
| 2428 | 1356 | 1 | 2015-11-08 10:49:56 |
| 2429 | 1356 | 3 | 2015-11-08 11:26:57 |
| 2430 | 1356 | 1 | 2015-11-08 12:31:54 |
| 2431 | 1329 | 2 | 2015-11-08 16:33:30 |
| 2432 | 1330 | 2 | 2015-11-08 16:37:02 |
| 2433 | 1328 | 2 | 2015-11-08 16:37:52 |
| 2434 | 1371 | 2 | 2015-11-09 12:19:13 |
| 2435 | 1428 | 2 | 2015-11-09 15:48:15 |
| 2436 | 1427 | 2 | 2015-11-09 15:51:19 |
| 2437 | 1428 | 1 | 2015-11-09 16:30:45 |
| 2438 | 1427 | 1 | 2015-11-09 16:48:04 |
| 2439 | 1428 | 2 | 2015-11-09 17:46:16 |
| 2440 | 1141 | 1 | 2015-11-10 09:57:01 |
| 2441 | 1144 | 1 | 2015-11-10 09:57:38 |
| 2442 | 1160 | 1 | 2015-11-10 09:59:32 |
| 2443 | 1153 | 1 | 2015-11-10 09:59:33 |
| 2444 | 1154 | 1 | 2015-11-10 10:00:05 |
| 2445 | 1134 | 1 | 2015-11-10 10:00:23 |
| 2446 | 1152 | 1 | 2015-11-10 10:00:48 |
| 2447 | 1135 | 1 | 2015-11-10 10:01:31 |
| 2448 | 1159 | 1 | 2015-11-10 10:01:33 |
| 2449 | 1136 | 1 | 2015-11-10 10:02:08 |
| 2450 | 1142 | 1 | 2015-11-10 10:02:25 |
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;