Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,926–3,950 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3926 | 2040 | 2 | 2016-04-10 11:51:08 |
| 3927 | 2040 | 1 | 2016-04-10 12:59:10 |
| 3928 | 1978 | 1 | 2016-04-10 13:04:40 |
| 3929 | 2041 | 1 | 2016-04-10 13:06:52 |
| 3930 | 2042 | 2 | 2016-04-10 13:07:26 |
| 3931 | 2040 | 3 | 2016-04-10 14:14:32 |
| 3932 | 2042 | 3 | 2016-04-10 14:36:04 |
| 3933 | 2046 | 2 | 2016-04-10 15:09:41 |
| 3934 | 2045 | 2 | 2016-04-10 15:11:23 |
| 3935 | 2042 | 2 | 2016-04-10 15:13:05 |
| 3936 | 2043 | 2 | 2016-04-10 15:13:32 |
| 3937 | 2044 | 2 | 2016-04-10 15:15:24 |
| 3938 | 2042 | 1 | 2016-04-10 15:40:55 |
| 3939 | 2045 | 1 | 2016-04-10 16:03:46 |
| 3940 | 2046 | 1 | 2016-04-10 16:23:37 |
| 3941 | 2044 | 1 | 2016-04-10 16:23:53 |
| 3942 | 2043 | 1 | 2016-04-10 16:48:40 |
| 3943 | 2058 | 2 | 2016-04-14 11:39:24 |
| 3944 | 2057 | 2 | 2016-04-14 11:44:52 |
| 3945 | 2058 | 1 | 2016-04-14 12:08:05 |
| 3946 | 2057 | 1 | 2016-04-14 12:40:15 |
| 3947 | 2060 | 2 | 2016-04-14 13:52:42 |
| 3948 | 2061 | 2 | 2016-04-14 13:55:07 |
| 3949 | 2059 | 2 | 2016-04-14 13:57:20 |
| 3950 | 2062 | 2 | 2016-04-14 14:06: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;