Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,951–7,975 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7951 | 4057 | 3 | 2017-06-21 11:30:44 |
| 7952 | 4072 | 2 | 2017-06-21 12:11:23 |
| 7953 | 4069 | 3 | 2017-06-21 12:11:58 |
| 7954 | 4070 | 2 | 2017-06-21 12:20:04 |
| 7955 | 4071 | 1 | 2017-06-21 12:20:17 |
| 7956 | 4071 | 2 | 2017-06-21 13:00:18 |
| 7957 | 4069 | 1 | 2017-06-21 13:04:02 |
| 7958 | 4070 | 3 | 2017-06-21 13:16:21 |
| 7959 | 4070 | 2 | 2017-06-21 13:50:01 |
| 7960 | 4071 | 1 | 2017-06-21 14:12:46 |
| 7961 | 4069 | 2 | 2017-06-21 14:36:33 |
| 7962 | 4077 | 2 | 2017-06-22 14:42:05 |
| 7963 | 4075 | 2 | 2017-06-22 14:42:17 |
| 7964 | 4078 | 2 | 2017-06-22 14:53:59 |
| 7965 | 4076 | 2 | 2017-06-22 14:58:26 |
| 7966 | 4078 | 3 | 2017-06-22 15:43:44 |
| 7967 | 4075 | 3 | 2017-06-22 15:45:41 |
| 7968 | 4076 | 3 | 2017-06-22 15:49:55 |
| 7969 | 4077 | 3 | 2017-06-22 16:11:00 |
| 7970 | 4079 | 2 | 2017-06-23 15:24:00 |
| 7971 | 4079 | 3 | 2017-06-23 16:25:03 |
| 7972 | 4079 | 1 | 2017-06-23 17:42:17 |
| 7973 | 4061 | 2 | 2017-06-24 11:23:55 |
| 7974 | 4085 | 1 | 2017-06-24 11:49:32 |
| 7975 | 4086 | 1 | 2017-06-24 11:50:07 |
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;