Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,376–2,400 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2376 | 1346 | 3 | 2015-10-23 11:48:58 |
| 2377 | 1349 | 3 | 2015-10-23 11:49:40 |
| 2378 | 1348 | 3 | 2015-10-23 11:56:30 |
| 2379 | 1355 | 1 | 2015-10-25 09:35:30 |
| 2380 | 1323 | 1 | 2015-10-26 12:30:31 |
| 2381 | 1322 | 3 | 2015-10-26 12:46:10 |
| 2382 | 1323 | 3 | 2015-10-26 13:17:42 |
| 2383 | 1263 | 1 | 2015-10-26 13:24:20 |
| 2384 | 1264 | 1 | 2015-10-26 13:30:24 |
| 2385 | 1322 | 1 | 2015-10-26 13:43:41 |
| 2386 | 1350 | 2 | 2015-10-30 11:50:21 |
| 2387 | 1360 | 3 | 2015-10-30 12:18:09 |
| 2388 | 1350 | 3 | 2015-10-30 12:28:48 |
| 2389 | 1361 | 2 | 2015-10-31 09:57:03 |
| 2390 | 1370 | 2 | 2015-10-31 10:14:51 |
| 2391 | 1363 | 1 | 2015-10-31 10:14:55 |
| 2392 | 1362 | 1 | 2015-10-31 10:15:08 |
| 2393 | 1369 | 2 | 2015-10-31 10:15:33 |
| 2394 | 1368 | 3 | 2015-10-31 10:24:59 |
| 2395 | 1365 | 3 | 2015-10-31 10:28:29 |
| 2396 | 1366 | 3 | 2015-10-31 10:28:30 |
| 2397 | 1364 | 2 | 2015-10-31 10:28:38 |
| 2398 | 1367 | 3 | 2015-10-31 10:34:13 |
| 2399 | 1363 | 3 | 2015-10-31 11:13:57 |
| 2400 | 1370 | 3 | 2015-10-31 11:16:02 |
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;