Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,851–14,875 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14851 | 7718 | 1 | 2019-02-22 15:23:04 |
| 14852 | 7718 | 3 | 2019-02-22 16:39:33 |
| 14853 | 7721 | 1 | 2019-02-23 09:58:07 |
| 14854 | 7720 | 3 | 2019-02-23 10:00:15 |
| 14855 | 7720 | 1 | 2019-02-23 11:24:01 |
| 14856 | 7724 | 2 | 2019-02-24 11:52:27 |
| 14857 | 7725 | 3 | 2019-02-24 11:54:20 |
| 14858 | 7724 | 3 | 2019-02-24 13:10:30 |
| 14859 | 7719 | 2 | 2019-02-25 15:36:28 |
| 14860 | 7719 | 3 | 2019-02-25 17:04:15 |
| 14861 | 7085 | 2 | 2019-02-27 12:58:17 |
| 14862 | 7093 | 2 | 2019-02-27 12:59:14 |
| 14863 | 7102 | 2 | 2019-02-27 13:00:33 |
| 14864 | 7087 | 2 | 2019-02-27 13:01:33 |
| 14865 | 7097 | 2 | 2019-02-27 13:01:47 |
| 14866 | 7090 | 2 | 2019-02-27 13:02:16 |
| 14867 | 7103 | 2 | 2019-02-27 13:02:32 |
| 14868 | 7096 | 2 | 2019-02-27 13:02:34 |
| 14869 | 7098 | 2 | 2019-02-27 13:03:41 |
| 14870 | 7091 | 2 | 2019-02-27 13:03:54 |
| 14871 | 7100 | 2 | 2019-02-27 13:03:55 |
| 14872 | 7135 | 2 | 2019-02-27 13:04:21 |
| 14873 | 7106 | 2 | 2019-02-27 13:04:47 |
| 14874 | 7094 | 2 | 2019-02-27 13:04:59 |
| 14875 | 7109 | 2 | 2019-02-27 13:04:59 |
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;