Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,951–13,975 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13951 | 7189 | 2 | 2018-12-02 09:22:13 |
| 13952 | 7185 | 2 | 2018-12-02 09:23:40 |
| 13953 | 7186 | 2 | 2018-12-02 09:27:48 |
| 13954 | 7188 | 2 | 2018-12-02 09:33:37 |
| 13955 | 7189 | 3 | 2018-12-02 10:45:01 |
| 13956 | 7062 | 3 | 2018-12-02 11:20:11 |
| 13957 | 7220 | 3 | 2018-12-02 11:26:18 |
| 13958 | 7222 | 1 | 2018-12-02 11:26:50 |
| 13959 | 7221 | 1 | 2018-12-02 11:33:55 |
| 13960 | 7219 | 3 | 2018-12-02 11:35:57 |
| 13961 | 7157 | 2 | 2018-12-02 12:31:14 |
| 13962 | 7154 | 2 | 2018-12-02 12:34:53 |
| 13963 | 7062 | 1 | 2018-12-02 12:44:38 |
| 13964 | 7156 | 2 | 2018-12-02 12:44:42 |
| 13965 | 7155 | 2 | 2018-12-02 12:46:49 |
| 13966 | 7221 | 3 | 2018-12-02 12:48:31 |
| 13967 | 7222 | 3 | 2018-12-02 12:50:09 |
| 13968 | 7157 | 1 | 2018-12-02 13:38:22 |
| 13969 | 7156 | 1 | 2018-12-02 13:45:44 |
| 13970 | 7155 | 1 | 2018-12-02 13:50:40 |
| 13971 | 7154 | 1 | 2018-12-02 13:55:52 |
| 13972 | 7062 | 3 | 2018-12-02 14:04:51 |
| 13973 | 7155 | 3 | 2018-12-02 14:35:11 |
| 13974 | 7156 | 3 | 2018-12-02 14:45:32 |
| 13975 | 7157 | 3 | 2018-12-02 14:58:05 |
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;