Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,951–14,975 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14951 | 7742 | 2 | 2019-03-02 10:47:23 |
| 14952 | 7743 | 2 | 2019-03-02 10:49:09 |
| 14953 | 7741 | 3 | 2019-03-02 10:57:25 |
| 14954 | 7744 | 2 | 2019-03-02 11:00:16 |
| 14955 | 7743 | 3 | 2019-03-02 11:29:43 |
| 14956 | 7744 | 3 | 2019-03-02 11:30:24 |
| 14957 | 7745 | 3 | 2019-03-02 11:33:13 |
| 14958 | 7742 | 3 | 2019-03-02 12:12:11 |
| 14959 | 7744 | 1 | 2019-03-02 12:15:35 |
| 14960 | 7743 | 1 | 2019-03-02 12:20:40 |
| 14961 | 7743 | 2 | 2019-03-02 12:58:30 |
| 14962 | 7745 | 2 | 2019-03-02 13:04:47 |
| 14963 | 7744 | 2 | 2019-03-02 13:27:11 |
| 14964 | 7742 | 1 | 2019-03-02 13:35:46 |
| 14965 | 7742 | 2 | 2019-03-02 14:16:31 |
| 14966 | 7717 | 2 | 2019-03-03 12:49:52 |
| 14967 | 7716 | 3 | 2019-03-03 12:58:35 |
| 14968 | 7717 | 1 | 2019-03-03 13:59:41 |
| 14969 | 7717 | 2 | 2019-03-03 14:41:17 |
| 14970 | 7756 | 2 | 2019-03-04 10:38:16 |
| 14971 | 7754 | 2 | 2019-03-04 10:41:43 |
| 14972 | 7755 | 2 | 2019-03-04 10:42:16 |
| 14973 | 7762 | 2 | 2019-03-05 09:45:05 |
| 14974 | 7764 | 2 | 2019-03-05 09:50:19 |
| 14975 | 7765 | 2 | 2019-03-05 09:53:56 |
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;