Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,901–3,925 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3901 | 2016 | 2 | 2016-04-01 16:51:06 |
| 3902 | 2024 | 2 | 2016-04-01 17:02:50 |
| 3903 | 2023 | 1 | 2016-04-01 17:24:25 |
| 3904 | 1965 | 2 | 2016-04-03 13:07:54 |
| 3905 | 1966 | 2 | 2016-04-03 13:09:08 |
| 3906 | 1965 | 3 | 2016-04-03 14:01:11 |
| 3907 | 1966 | 3 | 2016-04-03 14:39:34 |
| 3908 | 2028 | 3 | 2016-04-05 11:56:19 |
| 3909 | 2028 | 2 | 2016-04-05 13:02:45 |
| 3910 | 2029 | 3 | 2016-04-06 11:30:29 |
| 3911 | 2029 | 2 | 2016-04-06 12:45:56 |
| 3912 | 2029 | 3 | 2016-04-06 14:08:21 |
| 3913 | 1887 | 2 | 2016-04-07 12:27:26 |
| 3914 | 1887 | 3 | 2016-04-07 13:31:19 |
| 3915 | 2030 | 1 | 2016-04-07 16:01:18 |
| 3916 | 1983 | 2 | 2016-04-08 11:12:11 |
| 3917 | 2032 | 1 | 2016-04-08 12:48:11 |
| 3918 | 2031 | 1 | 2016-04-08 12:48:17 |
| 3919 | 2034 | 1 | 2016-04-08 12:56:51 |
| 3920 | 2033 | 1 | 2016-04-08 12:59:34 |
| 3921 | 2034 | 3 | 2016-04-08 13:48:03 |
| 3922 | 2032 | 3 | 2016-04-08 13:58:55 |
| 3923 | 2033 | 3 | 2016-04-08 14:08:21 |
| 3924 | 2031 | 3 | 2016-04-08 14:08:53 |
| 3925 | 2039 | 2 | 2016-04-10 11:43:40 |
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;