Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,401–11,425 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11401 | 5885 | 1 | 2018-06-02 14:37:56 |
| 11402 | 5893 | 1 | 2018-06-02 15:00:45 |
| 11403 | 5885 | 3 | 2018-06-02 15:24:38 |
| 11404 | 5893 | 3 | 2018-06-02 16:10:13 |
| 11405 | 5893 | 1 | 2018-06-02 16:36:23 |
| 11406 | 5895 | 2 | 2018-06-04 10:10:45 |
| 11407 | 5894 | 2 | 2018-06-04 10:18:39 |
| 11408 | 5939 | 3 | 2018-06-04 10:50:20 |
| 11409 | 5894 | 1 | 2018-06-04 11:30:04 |
| 11410 | 5939 | 2 | 2018-06-04 11:54:24 |
| 11411 | 5705 | 2 | 2018-06-04 11:58:20 |
| 11412 | 5939 | 1 | 2018-06-04 12:27:54 |
| 11413 | 5705 | 1 | 2018-06-04 13:26:10 |
| 11414 | 5705 | 2 | 2018-06-04 13:54:50 |
| 11415 | 5881 | 2 | 2018-06-05 13:37:36 |
| 11416 | 5878 | 2 | 2018-06-05 13:42:11 |
| 11417 | 5879 | 2 | 2018-06-05 13:44:47 |
| 11418 | 5880 | 2 | 2018-06-05 13:49:15 |
| 11419 | 5879 | 3 | 2018-06-05 14:14:03 |
| 11420 | 5879 | 2 | 2018-06-05 15:30:06 |
| 11421 | 5944 | 2 | 2018-06-06 12:41:19 |
| 11422 | 5943 | 3 | 2018-06-06 12:43:08 |
| 11423 | 5945 | 2 | 2018-06-06 12:51:27 |
| 11424 | 5942 | 2 | 2018-06-06 12:52:21 |
| 11425 | 5943 | 2 | 2018-06-06 13:44:10 |
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;