Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,926–8,950 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8926 | 4226 | 2 | 2017-09-20 14:04:46 |
| 8927 | 4217 | 2 | 2017-09-20 14:05:33 |
| 8928 | 4204 | 2 | 2017-09-20 14:05:43 |
| 8929 | 4197 | 2 | 2017-09-20 14:07:14 |
| 8930 | 4199 | 2 | 2017-09-20 14:10:10 |
| 8931 | 4224 | 2 | 2017-09-20 14:14:36 |
| 8932 | 4216 | 2 | 2017-09-20 14:16:09 |
| 8933 | 4213 | 2 | 2017-09-20 14:16:44 |
| 8934 | 4196 | 2 | 2017-09-20 14:18:45 |
| 8935 | 4202 | 2 | 2017-09-20 14:21:14 |
| 8936 | 4231 | 2 | 2017-09-20 14:24:07 |
| 8937 | 4209 | 2 | 2017-09-20 14:24:23 |
| 8938 | 4237 | 2 | 2017-09-20 14:25:34 |
| 8939 | 4200 | 2 | 2017-09-20 14:28:44 |
| 8940 | 4234 | 2 | 2017-09-20 14:32:40 |
| 8941 | 4533 | 2 | 2017-09-22 10:27:39 |
| 8942 | 4532 | 2 | 2017-09-22 10:30:31 |
| 8943 | 4657 | 1 | 2017-09-22 11:19:26 |
| 8944 | 4656 | 1 | 2017-09-22 11:19:29 |
| 8945 | 4657 | 3 | 2017-09-22 12:09:45 |
| 8946 | 4656 | 3 | 2017-09-22 12:19:14 |
| 8947 | 4660 | 2 | 2017-09-22 15:14:12 |
| 8948 | 4661 | 3 | 2017-09-22 15:17:32 |
| 8949 | 4660 | 1 | 2017-09-22 15:41:21 |
| 8950 | 4661 | 2 | 2017-09-22 16:06:44 |
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;