Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,651–17,675 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17651 | 8953 | 2 | 2019-09-13 12:08:11 |
| 17652 | 8955 | 2 | 2019-09-13 12:51:08 |
| 17653 | 8954 | 2 | 2019-09-13 13:01:04 |
| 17654 | 8950 | 2 | 2019-09-14 09:24:14 |
| 17655 | 8950 | 3 | 2019-09-14 10:10:40 |
| 17656 | 8950 | 2 | 2019-09-14 11:17:05 |
| 17657 | 9013 | 1 | 2019-09-14 12:04:18 |
| 17658 | 9012 | 2 | 2019-09-14 12:09:20 |
| 17659 | 8950 | 3 | 2019-09-14 12:13:52 |
| 17660 | 9013 | 3 | 2019-09-14 13:20:08 |
| 17661 | 8952 | 2 | 2019-09-14 14:43:24 |
| 17662 | 8951 | 2 | 2019-09-14 14:46:58 |
| 17663 | 9013 | 2 | 2019-09-14 14:47:37 |
| 17664 | 9011 | 1 | 2019-09-15 09:35:00 |
| 17665 | 9011 | 3 | 2019-09-15 10:15:09 |
| 17666 | 9024 | 2 | 2019-09-15 10:25:45 |
| 17667 | 9023 | 2 | 2019-09-15 10:34:43 |
| 17668 | 9025 | 2 | 2019-09-15 10:37:41 |
| 17669 | 9011 | 1 | 2019-09-15 10:50:25 |
| 17670 | 9025 | 3 | 2019-09-15 12:00:14 |
| 17671 | 8948 | 1 | 2019-09-15 12:15:03 |
| 17672 | 9014 | 2 | 2019-09-15 12:23:34 |
| 17673 | 9017 | 2 | 2019-09-15 12:27:15 |
| 17674 | 9018 | 2 | 2019-09-15 12:27:37 |
| 17675 | 9016 | 2 | 2019-09-15 12:30:11 |
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;