Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,401–1,425 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1401 | 815 | 1 | 2015-07-20 17:04:47 |
| 1402 | 816 | 1 | 2015-07-20 17:12:12 |
| 1403 | 815 | 2 | 2015-07-20 17:49:20 |
| 1404 | 817 | 2 | 2015-07-21 10:02:05 |
| 1405 | 817 | 1 | 2015-07-21 11:32:12 |
| 1406 | 818 | 2 | 2015-07-21 11:38:40 |
| 1407 | 820 | 1 | 2015-07-21 11:48:05 |
| 1408 | 819 | 2 | 2015-07-21 11:49:58 |
| 1409 | 822 | 2 | 2015-07-21 12:00:20 |
| 1410 | 821 | 2 | 2015-07-21 12:02:53 |
| 1411 | 823 | 1 | 2015-07-21 12:03:16 |
| 1412 | 824 | 1 | 2015-07-21 12:04:33 |
| 1413 | 820 | 2 | 2015-07-21 12:17:14 |
| 1414 | 823 | 3 | 2015-07-21 13:00:09 |
| 1415 | 822 | 3 | 2015-07-21 13:26:24 |
| 1416 | 821 | 1 | 2015-07-21 13:34:26 |
| 1417 | 820 | 1 | 2015-07-21 13:46:25 |
| 1418 | 823 | 1 | 2015-07-21 14:07:34 |
| 1419 | 821 | 3 | 2015-07-21 14:48:54 |
| 1420 | 820 | 2 | 2015-07-21 15:02:35 |
| 1421 | 826 | 2 | 2015-07-22 12:03:33 |
| 1422 | 827 | 2 | 2015-07-22 12:08:41 |
| 1423 | 826 | 3 | 2015-07-22 12:31:15 |
| 1424 | 791 | 2 | 2015-07-22 12:33:37 |
| 1425 | 792 | 2 | 2015-07-22 12:38:12 |
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;