Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,376–11,400 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11376 | 5875 | 1 | 2018-05-31 11:15:40 |
| 11377 | 5738 | 3 | 2018-05-31 12:02:56 |
| 11378 | 5875 | 2 | 2018-05-31 12:37:07 |
| 11379 | 5876 | 2 | 2018-05-31 12:46:57 |
| 11380 | 5877 | 2 | 2018-05-31 12:51:07 |
| 11381 | 5876 | 1 | 2018-05-31 14:07:12 |
| 11382 | 5877 | 1 | 2018-05-31 14:17:36 |
| 11383 | 5874 | 2 | 2018-05-31 17:09:22 |
| 11384 | 5873 | 2 | 2018-05-31 17:15:34 |
| 11385 | 5822 | 1 | 2018-06-01 10:47:33 |
| 11386 | 5822 | 3 | 2018-06-01 11:24:00 |
| 11387 | 5817 | 2 | 2018-06-01 11:54:32 |
| 11388 | 5817 | 1 | 2018-06-01 12:56:39 |
| 11389 | 5891 | 3 | 2018-06-02 11:01:04 |
| 11390 | 5892 | 3 | 2018-06-02 11:09:39 |
| 11391 | 5814 | 2 | 2018-06-02 11:52:41 |
| 11392 | 5885 | 2 | 2018-06-02 11:58:03 |
| 11393 | 5813 | 1 | 2018-06-02 12:02:29 |
| 11394 | 5796 | 2 | 2018-06-02 12:41:49 |
| 11395 | 5795 | 2 | 2018-06-02 12:56:18 |
| 11396 | 5885 | 3 | 2018-06-02 13:17:49 |
| 11397 | 5814 | 1 | 2018-06-02 13:27:36 |
| 11398 | 5795 | 1 | 2018-06-02 13:32:39 |
| 11399 | 5796 | 1 | 2018-06-02 13:37:35 |
| 11400 | 5893 | 3 | 2018-06-02 14:27:00 |
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;