Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,951–10,975 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10951 | 5098 | 2 | 2018-05-04 12:38:34 |
| 10952 | 5090 | 2 | 2018-05-04 12:38:36 |
| 10953 | 5117 | 2 | 2018-05-04 12:38:48 |
| 10954 | 5115 | 2 | 2018-05-04 12:39:01 |
| 10955 | 5094 | 2 | 2018-05-04 12:39:40 |
| 10956 | 5091 | 2 | 2018-05-04 12:39:47 |
| 10957 | 5104 | 2 | 2018-05-04 12:40:35 |
| 10958 | 5074 | 2 | 2018-05-04 12:41:57 |
| 10959 | 5109 | 2 | 2018-05-04 12:42:02 |
| 10960 | 5103 | 2 | 2018-05-04 12:42:24 |
| 10961 | 5085 | 2 | 2018-05-04 12:42:31 |
| 10962 | 5120 | 2 | 2018-05-04 12:42:47 |
| 10963 | 5082 | 2 | 2018-05-04 12:43:06 |
| 10964 | 5100 | 2 | 2018-05-04 12:43:49 |
| 10965 | 5068 | 2 | 2018-05-04 12:44:01 |
| 10966 | 5095 | 2 | 2018-05-04 12:44:30 |
| 10967 | 5078 | 2 | 2018-05-04 12:44:38 |
| 10968 | 5093 | 2 | 2018-05-04 12:44:47 |
| 10969 | 5083 | 2 | 2018-05-04 12:44:48 |
| 10970 | 5097 | 2 | 2018-05-04 12:44:50 |
| 10971 | 5099 | 2 | 2018-05-04 12:47:44 |
| 10972 | 5111 | 2 | 2018-05-04 12:48:20 |
| 10973 | 5116 | 2 | 2018-05-04 12:49:00 |
| 10974 | 5122 | 2 | 2018-05-04 12:49:58 |
| 10975 | 5108 | 2 | 2018-05-04 12:50:42 |
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;