Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,426–10,450 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10426 | 5352 | 2 | 2018-03-17 10:21:54 |
| 10427 | 5352 | 3 | 2018-03-17 11:19:43 |
| 10428 | 5433 | 1 | 2018-03-17 11:32:35 |
| 10429 | 5434 | 1 | 2018-03-17 11:33:52 |
| 10430 | 5435 | 1 | 2018-03-17 11:45:30 |
| 10431 | 5432 | 1 | 2018-03-17 11:46:51 |
| 10432 | 5433 | 2 | 2018-03-17 12:03:08 |
| 10433 | 5435 | 2 | 2018-03-17 12:32:16 |
| 10434 | 5432 | 2 | 2018-03-17 12:46:02 |
| 10435 | 5434 | 2 | 2018-03-17 12:53:25 |
| 10436 | 5438 | 2 | 2018-03-18 10:52:52 |
| 10437 | 5437 | 3 | 2018-03-18 10:59:35 |
| 10438 | 5439 | 2 | 2018-03-18 11:22:33 |
| 10439 | 5440 | 2 | 2018-03-18 11:31:19 |
| 10440 | 5440 | 1 | 2018-03-18 12:07:32 |
| 10441 | 5439 | 1 | 2018-03-18 12:52:47 |
| 10442 | 5440 | 2 | 2018-03-18 12:57:09 |
| 10443 | 5440 | 1 | 2018-03-18 13:51:54 |
| 10444 | 5436 | 2 | 2018-03-18 16:40:45 |
| 10445 | 5436 | 1 | 2018-03-18 17:07:32 |
| 10446 | 5445 | 3 | 2018-03-20 13:18:37 |
| 10447 | 5446 | 3 | 2018-03-20 13:22:02 |
| 10448 | 5449 | 3 | 2018-03-20 13:24:13 |
| 10449 | 5448 | 3 | 2018-03-20 13:27:50 |
| 10450 | 5447 | 3 | 2018-03-20 13:28:43 |
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;