Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 19,426–19,450 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 19426 | 9804 | 2 | 2020-02-15 09:47:43 |
| 19427 | 9773 | 2 | 2020-02-15 09:48:14 |
| 19428 | 9773 | 3 | 2020-02-15 10:43:57 |
| 19429 | 9794 | 1 | 2020-02-15 11:08:15 |
| 19430 | 9793 | 1 | 2020-02-15 11:12:09 |
| 19431 | 9792 | 1 | 2020-02-15 11:21:54 |
| 19432 | 9774 | 1 | 2020-02-15 11:52:28 |
| 19433 | 9774 | 2 | 2020-02-15 13:14:10 |
| 19434 | 9813 | 3 | 2020-02-16 15:27:15 |
| 19435 | 9779 | 1 | 2020-02-16 16:15:51 |
| 19436 | 9780 | 1 | 2020-02-16 16:20:32 |
| 19437 | 9815 | 3 | 2020-02-17 09:27:05 |
| 19438 | 9814 | 3 | 2020-02-17 09:31:36 |
| 19439 | 9815 | 2 | 2020-02-17 09:58:15 |
| 19440 | 9814 | 2 | 2020-02-17 10:08:31 |
| 19441 | 9814 | 1 | 2020-02-17 10:47:07 |
| 19442 | 9803 | 2 | 2020-02-17 11:06:22 |
| 19443 | 9815 | 1 | 2020-02-17 11:08:21 |
| 19444 | 9802 | 2 | 2020-02-17 11:09:00 |
| 19445 | 9814 | 3 | 2020-02-17 11:38:11 |
| 19446 | 9690 | 2 | 2020-02-17 11:48:00 |
| 19447 | 9803 | 3 | 2020-02-17 11:48:17 |
| 19448 | 9691 | 2 | 2020-02-17 11:54:16 |
| 19449 | 9692 | 2 | 2020-02-17 11:55:48 |
| 19450 | 9811 | 3 | 2020-02-17 12:12:47 |
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;