Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,401–17,425 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17401 | 8762 | 2 | 2019-08-25 10:50:58 |
| 17402 | 8766 | 2 | 2019-08-25 10:56:40 |
| 17403 | 8765 | 2 | 2019-08-25 10:58:21 |
| 17404 | 8765 | 1 | 2019-08-25 11:24:15 |
| 17405 | 8766 | 3 | 2019-08-25 11:32:44 |
| 17406 | 8762 | 3 | 2019-08-25 11:33:35 |
| 17407 | 8764 | 3 | 2019-08-25 12:14:58 |
| 17408 | 8763 | 3 | 2019-08-25 12:15:02 |
| 17409 | 8691 | 1 | 2019-08-25 13:19:21 |
| 17410 | 8692 | 1 | 2019-08-25 13:29:45 |
| 17411 | 8820 | 3 | 2019-08-25 14:30:59 |
| 17412 | 8786 | 3 | 2019-08-25 14:35:14 |
| 17413 | 8787 | 3 | 2019-08-25 14:37:08 |
| 17414 | 8821 | 2 | 2019-08-25 14:42:09 |
| 17415 | 8691 | 2 | 2019-08-25 14:48:14 |
| 17416 | 8820 | 1 | 2019-08-25 15:00:19 |
| 17417 | 8787 | 2 | 2019-08-25 15:36:52 |
| 17418 | 8821 | 3 | 2019-08-25 15:59:19 |
| 17419 | 8691 | 1 | 2019-08-25 16:05:24 |
| 17420 | 8786 | 2 | 2019-08-25 16:06:44 |
| 17421 | 8820 | 3 | 2019-08-25 16:28:04 |
| 17422 | 8821 | 1 | 2019-08-25 17:20:33 |
| 17423 | 8594 | 2 | 2019-08-26 12:12:06 |
| 17424 | 8830 | 3 | 2019-08-26 14:15:09 |
| 17425 | 8829 | 3 | 2019-08-26 14:24:29 |
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;