Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,426–1,450 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1426 | 828 | 2 | 2015-07-22 12:42:20 |
| 1427 | 793 | 2 | 2015-07-22 12:46:29 |
| 1428 | 829 | 2 | 2015-07-22 12:47:05 |
| 1429 | 830 | 3 | 2015-07-22 13:10:39 |
| 1430 | 793 | 1 | 2015-07-22 13:16:42 |
| 1431 | 831 | 2 | 2015-07-22 13:18:10 |
| 1432 | 791 | 1 | 2015-07-22 13:25:39 |
| 1433 | 830 | 1 | 2015-07-22 13:53:52 |
| 1434 | 792 | 1 | 2015-07-22 13:59:30 |
| 1435 | 831 | 3 | 2015-07-22 14:16:31 |
| 1436 | 831 | 1 | 2015-07-22 15:43:10 |
| 1437 | 813 | 3 | 2015-07-23 09:21:29 |
| 1438 | 812 | 3 | 2015-07-23 09:30:53 |
| 1439 | 812 | 1 | 2015-07-23 10:14:04 |
| 1440 | 805 | 2 | 2015-07-23 10:34:31 |
| 1441 | 813 | 1 | 2015-07-23 10:40:14 |
| 1442 | 832 | 1 | 2015-07-23 11:28:20 |
| 1443 | 833 | 3 | 2015-07-23 11:31:57 |
| 1444 | 805 | 3 | 2015-07-23 11:44:07 |
| 1445 | 832 | 3 | 2015-07-23 12:27:08 |
| 1446 | 834 | 3 | 2015-07-23 13:22:30 |
| 1447 | 835 | 1 | 2015-07-23 14:37:28 |
| 1448 | 834 | 1 | 2015-07-23 14:54:32 |
| 1449 | 835 | 2 | 2015-07-23 15:50:51 |
| 1450 | 835 | 3 | 2015-07-23 17:08:50 |
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;