Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,951–17,975 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17951 | 9053 | 1 | 2019-10-26 09:35:12 |
| 17952 | 9030 | 1 | 2019-10-26 09:35:59 |
| 17953 | 9027 | 1 | 2019-10-26 09:36:29 |
| 17954 | 9061 | 1 | 2019-10-26 09:37:29 |
| 17955 | 9041 | 1 | 2019-10-26 09:37:34 |
| 17956 | 9044 | 1 | 2019-10-26 09:38:03 |
| 17957 | 9055 | 1 | 2019-10-26 09:38:15 |
| 17958 | 9029 | 1 | 2019-10-26 09:38:19 |
| 17959 | 9037 | 1 | 2019-10-26 09:38:45 |
| 17960 | 9068 | 1 | 2019-10-26 09:38:56 |
| 17961 | 9051 | 1 | 2019-10-26 09:38:57 |
| 17962 | 9060 | 1 | 2019-10-26 09:39:07 |
| 17963 | 9066 | 1 | 2019-10-26 09:39:58 |
| 17964 | 9050 | 1 | 2019-10-26 09:40:10 |
| 17965 | 9033 | 1 | 2019-10-26 09:40:40 |
| 17966 | 9081 | 1 | 2019-10-26 09:41:05 |
| 17967 | 9048 | 1 | 2019-10-26 09:41:24 |
| 17968 | 9047 | 1 | 2019-10-26 09:41:34 |
| 17969 | 9067 | 1 | 2019-10-26 09:42:10 |
| 17970 | 9070 | 1 | 2019-10-26 09:43:00 |
| 17971 | 9073 | 1 | 2019-10-26 09:43:01 |
| 17972 | 9078 | 1 | 2019-10-26 09:43:20 |
| 17973 | 9031 | 1 | 2019-10-26 09:43:41 |
| 17974 | 9034 | 1 | 2019-10-26 09:44:05 |
| 17975 | 9052 | 1 | 2019-10-26 09:44:24 |
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;