Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,501–2,525 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2501 | 1159 | 3 | 2015-11-10 11:10:25 |
| 2502 | 1174 | 3 | 2015-11-10 11:11:09 |
| 2503 | 1170 | 3 | 2015-11-10 11:15:05 |
| 2504 | 1165 | 1 | 2015-11-10 11:17:23 |
| 2505 | 1135 | 3 | 2015-11-10 11:17:51 |
| 2506 | 1166 | 1 | 2015-11-10 11:19:45 |
| 2507 | 1169 | 3 | 2015-11-10 11:20:09 |
| 2508 | 1140 | 3 | 2015-11-10 11:24:32 |
| 2509 | 1162 | 3 | 2015-11-10 11:27:28 |
| 2510 | 1144 | 3 | 2015-11-10 11:27:55 |
| 2511 | 1147 | 3 | 2015-11-10 11:29:07 |
| 2512 | 1160 | 3 | 2015-11-10 11:30:38 |
| 2513 | 1164 | 3 | 2015-11-10 11:31:06 |
| 2514 | 1136 | 3 | 2015-11-10 11:31:45 |
| 2515 | 1152 | 3 | 2015-11-10 11:33:50 |
| 2516 | 1154 | 3 | 2015-11-10 11:34:33 |
| 2517 | 1155 | 3 | 2015-11-10 11:36:37 |
| 2518 | 1139 | 1 | 2015-11-10 11:37:56 |
| 2519 | 1171 | 1 | 2015-11-10 11:42:16 |
| 2520 | 1137 | 3 | 2015-11-10 11:44:00 |
| 2521 | 1158 | 3 | 2015-11-10 11:47:34 |
| 2522 | 1150 | 3 | 2015-11-10 11:47:57 |
| 2523 | 1145 | 3 | 2015-11-10 11:50:21 |
| 2524 | 1174 | 1 | 2015-11-10 11:52:29 |
| 2525 | 1159 | 1 | 2015-11-10 11:57:39 |
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;