Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,301–2,325 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2301 | 1109 | 3 | 2015-10-13 14:29:49 |
| 2302 | 1101 | 3 | 2015-10-13 14:31:05 |
| 2303 | 1095 | 3 | 2015-10-13 14:33:12 |
| 2304 | 1116 | 3 | 2015-10-13 14:35:33 |
| 2305 | 1123 | 3 | 2015-10-13 14:39:04 |
| 2306 | 1106 | 3 | 2015-10-13 14:41:36 |
| 2307 | 1118 | 3 | 2015-10-13 14:45:10 |
| 2308 | 1117 | 3 | 2015-10-13 14:46:12 |
| 2309 | 1102 | 3 | 2015-10-13 14:48:09 |
| 2310 | 1108 | 3 | 2015-10-13 14:48:58 |
| 2311 | 1277 | 3 | 2015-10-13 14:50:48 |
| 2312 | 1107 | 3 | 2015-10-13 14:51:19 |
| 2313 | 1096 | 3 | 2015-10-13 14:53:54 |
| 2314 | 1094 | 3 | 2015-10-13 14:54:01 |
| 2315 | 1121 | 3 | 2015-10-13 14:57:13 |
| 2316 | 1119 | 3 | 2015-10-13 14:58:52 |
| 2317 | 1278 | 3 | 2015-10-13 15:02:53 |
| 2318 | 1099 | 3 | 2015-10-13 15:08:46 |
| 2319 | 1091 | 3 | 2015-10-13 15:09:32 |
| 2320 | 1114 | 3 | 2015-10-13 15:10:55 |
| 2321 | 1124 | 3 | 2015-10-13 15:15:19 |
| 2322 | 1115 | 3 | 2015-10-13 15:25:23 |
| 2323 | 1317 | 2 | 2015-10-14 11:49:15 |
| 2324 | 1319 | 1 | 2015-10-14 11:52:12 |
| 2325 | 1318 | 1 | 2015-10-14 11:57:06 |
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;