Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,301–11,325 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11301 | 5771 | 1 | 2018-05-23 11:14:41 |
| 11302 | 5771 | 2 | 2018-05-23 11:54:33 |
| 11303 | 5772 | 3 | 2018-05-23 11:54:41 |
| 11304 | 5769 | 2 | 2018-05-23 12:07:30 |
| 11305 | 5771 | 1 | 2018-05-23 12:22:50 |
| 11306 | 5770 | 1 | 2018-05-23 12:23:48 |
| 11307 | 5810 | 3 | 2018-05-23 12:28:23 |
| 11308 | 5769 | 1 | 2018-05-23 13:26:59 |
| 11309 | 5770 | 3 | 2018-05-23 13:39:05 |
| 11310 | 5810 | 2 | 2018-05-23 14:01:32 |
| 11311 | 5812 | 3 | 2018-05-23 15:07:29 |
| 11312 | 5811 | 3 | 2018-05-23 15:08:10 |
| 11313 | 5812 | 1 | 2018-05-23 15:42:09 |
| 11314 | 5811 | 1 | 2018-05-23 15:43:10 |
| 11315 | 5784 | 3 | 2018-05-24 10:48:47 |
| 11316 | 5783 | 3 | 2018-05-24 10:50:50 |
| 11317 | 5742 | 2 | 2018-05-24 13:52:57 |
| 11318 | 5743 | 2 | 2018-05-24 13:54:40 |
| 11319 | 5744 | 2 | 2018-05-24 13:57:53 |
| 11320 | 5741 | 2 | 2018-05-24 14:04:20 |
| 11321 | 5815 | 2 | 2018-05-24 14:14:39 |
| 11322 | 5809 | 2 | 2018-05-24 14:23:57 |
| 11323 | 5816 | 1 | 2018-05-24 14:26:44 |
| 11324 | 5815 | 1 | 2018-05-24 14:51:13 |
| 11325 | 5809 | 3 | 2018-05-24 15:32:36 |
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;