Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,476–11,500 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11476 | 6031 | 1 | 2018-06-12 17:42:05 |
| 11477 | 5950 | 2 | 2018-06-13 10:56:32 |
| 11478 | 6025 | 1 | 2018-06-13 11:22:25 |
| 11479 | 5950 | 3 | 2018-06-13 11:32:16 |
| 11480 | 6025 | 2 | 2018-06-13 12:07:07 |
| 11481 | 5950 | 1 | 2018-06-13 12:24:01 |
| 11482 | 6042 | 2 | 2018-06-13 12:52:01 |
| 11483 | 6042 | 3 | 2018-06-13 13:37:00 |
| 11484 | 6041 | 3 | 2018-06-13 15:08:30 |
| 11485 | 6039 | 3 | 2018-06-13 15:11:20 |
| 11486 | 6040 | 3 | 2018-06-13 15:12:44 |
| 11487 | 6038 | 2 | 2018-06-13 15:13:17 |
| 11488 | 6037 | 3 | 2018-06-13 15:13:37 |
| 11489 | 6044 | 3 | 2018-06-13 15:50:26 |
| 11490 | 6043 | 3 | 2018-06-13 15:52:42 |
| 11491 | 6037 | 1 | 2018-06-13 16:09:22 |
| 11492 | 6040 | 1 | 2018-06-13 16:11:31 |
| 11493 | 6041 | 1 | 2018-06-13 16:18:51 |
| 11494 | 6039 | 1 | 2018-06-13 16:46:19 |
| 11495 | 6049 | 1 | 2018-06-15 10:38:32 |
| 11496 | 6046 | 2 | 2018-06-15 11:07:38 |
| 11497 | 6023 | 2 | 2018-06-15 11:12:03 |
| 11498 | 6024 | 2 | 2018-06-15 11:22:50 |
| 11499 | 6047 | 3 | 2018-06-15 11:36:13 |
| 11500 | 6049 | 3 | 2018-06-15 11:52: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;