Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,801–14,825 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14801 | 7390 | 2 | 2019-02-19 11:46:20 |
| 14802 | 7413 | 2 | 2019-02-19 11:46:24 |
| 14803 | 7422 | 2 | 2019-02-19 11:47:45 |
| 14804 | 7406 | 2 | 2019-02-19 11:48:54 |
| 14805 | 7403 | 2 | 2019-02-19 11:51:26 |
| 14806 | 7443 | 2 | 2019-02-19 11:51:53 |
| 14807 | 7396 | 2 | 2019-02-19 11:52:21 |
| 14808 | 7432 | 2 | 2019-02-19 11:53:57 |
| 14809 | 7397 | 2 | 2019-02-19 11:56:25 |
| 14810 | 7429 | 2 | 2019-02-19 11:58:27 |
| 14811 | 7415 | 2 | 2019-02-19 11:59:54 |
| 14812 | 7399 | 2 | 2019-02-19 12:00:01 |
| 14813 | 7419 | 2 | 2019-02-19 12:00:03 |
| 14814 | 7442 | 2 | 2019-02-19 12:01:59 |
| 14815 | 7416 | 2 | 2019-02-19 12:02:16 |
| 14816 | 7394 | 2 | 2019-02-19 12:02:28 |
| 14817 | 7408 | 2 | 2019-02-19 12:03:21 |
| 14818 | 7405 | 2 | 2019-02-19 12:07:10 |
| 14819 | 7440 | 2 | 2019-02-19 12:08:05 |
| 14820 | 7417 | 2 | 2019-02-19 12:09:29 |
| 14821 | 7395 | 2 | 2019-02-19 12:09:47 |
| 14822 | 7433 | 2 | 2019-02-19 12:16:23 |
| 14823 | 7427 | 2 | 2019-02-19 12:17:34 |
| 14824 | 7430 | 2 | 2019-02-19 12:18:28 |
| 14825 | 7410 | 2 | 2019-02-19 12:19:33 |
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;