Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,901–9,925 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9901 | 4862 | 2 | 2018-01-18 12:03:14 |
| 9902 | 4861 | 2 | 2018-01-18 12:07:03 |
| 9903 | 4862 | 1 | 2018-01-18 12:40:45 |
| 9904 | 4862 | 3 | 2018-01-18 13:17:09 |
| 9905 | 5203 | 1 | 2018-01-18 13:17:59 |
| 9906 | 4867 | 2 | 2018-01-19 09:12:42 |
| 9907 | 4868 | 2 | 2018-01-19 09:25:22 |
| 9908 | 5004 | 3 | 2018-01-19 13:16:25 |
| 9909 | 5003 | 3 | 2018-01-19 13:16:33 |
| 9910 | 5016 | 3 | 2018-01-19 13:17:48 |
| 9911 | 4997 | 3 | 2018-01-19 13:18:18 |
| 9912 | 5005 | 3 | 2018-01-19 13:19:02 |
| 9913 | 5010 | 3 | 2018-01-19 13:19:05 |
| 9914 | 5006 | 3 | 2018-01-19 13:19:44 |
| 9915 | 5022 | 3 | 2018-01-19 13:20:19 |
| 9916 | 5020 | 3 | 2018-01-19 13:20:47 |
| 9917 | 5002 | 3 | 2018-01-19 13:21:22 |
| 9918 | 5017 | 3 | 2018-01-19 13:22:07 |
| 9919 | 5025 | 3 | 2018-01-19 13:22:17 |
| 9920 | 5029 | 3 | 2018-01-19 13:22:19 |
| 9921 | 5021 | 3 | 2018-01-19 13:22:50 |
| 9922 | 5023 | 3 | 2018-01-19 13:23:57 |
| 9923 | 5000 | 3 | 2018-01-19 13:25:15 |
| 9924 | 5014 | 3 | 2018-01-19 13:25:28 |
| 9925 | 5001 | 3 | 2018-01-19 13:25:30 |
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;