Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,401–2,425 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2401 | 1369 | 3 | 2015-10-31 11:16:14 |
| 2402 | 1362 | 3 | 2015-10-31 11:35:56 |
| 2403 | 1364 | 1 | 2015-10-31 11:42:19 |
| 2404 | 1353 | 2 | 2015-10-31 12:29:10 |
| 2405 | 1354 | 2 | 2015-10-31 12:39:46 |
| 2406 | 1364 | 3 | 2015-10-31 12:48:51 |
| 2407 | 1353 | 1 | 2015-10-31 13:25:17 |
| 2408 | 1354 | 1 | 2015-10-31 13:49:27 |
| 2409 | 1364 | 2 | 2015-10-31 13:56:20 |
| 2410 | 1373 | 1 | 2015-11-02 10:57:42 |
| 2411 | 1373 | 2 | 2015-11-02 12:21:05 |
| 2412 | 1372 | 1 | 2015-11-03 10:45:46 |
| 2413 | 1359 | 1 | 2015-11-03 11:13:10 |
| 2414 | 1359 | 2 | 2015-11-03 11:40:15 |
| 2415 | 1372 | 3 | 2015-11-03 11:41:08 |
| 2416 | 1359 | 3 | 2015-11-03 12:23:47 |
| 2417 | 1359 | 1 | 2015-11-03 13:46:06 |
| 2418 | 1420 | 1 | 2015-11-04 10:39:48 |
| 2419 | 1341 | 3 | 2015-11-04 12:09:21 |
| 2420 | 1343 | 3 | 2015-11-04 12:11:54 |
| 2421 | 1342 | 3 | 2015-11-04 12:12:36 |
| 2422 | 1341 | 2 | 2015-11-04 12:41:07 |
| 2423 | 1342 | 2 | 2015-11-04 13:14:31 |
| 2424 | 1343 | 2 | 2015-11-04 13:26:04 |
| 2425 | 1417 | 2 | 2015-11-06 11:20:03 |
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;