Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,926–7,950 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7926 | 4051 | 1 | 2017-06-16 12:00:14 |
| 7927 | 4052 | 2 | 2017-06-16 12:08:37 |
| 7928 | 4053 | 2 | 2017-06-16 12:09:17 |
| 7929 | 4051 | 2 | 2017-06-16 12:35:02 |
| 7930 | 4056 | 2 | 2017-06-18 11:14:05 |
| 7931 | 4055 | 2 | 2017-06-18 16:08:53 |
| 7932 | 4054 | 2 | 2017-06-18 16:19:19 |
| 7933 | 3987 | 2 | 2017-06-18 16:25:13 |
| 7934 | 3986 | 2 | 2017-06-18 16:30:12 |
| 7935 | 4055 | 3 | 2017-06-18 16:42:29 |
| 7936 | 3987 | 3 | 2017-06-18 17:10:33 |
| 7937 | 3986 | 3 | 2017-06-18 17:28:39 |
| 7938 | 4055 | 2 | 2017-06-18 17:33:32 |
| 7939 | 4048 | 2 | 2017-06-19 10:11:12 |
| 7940 | 4063 | 2 | 2017-06-19 10:55:13 |
| 7941 | 4048 | 3 | 2017-06-19 10:55:26 |
| 7942 | 4063 | 3 | 2017-06-19 12:25:02 |
| 7943 | 4065 | 3 | 2017-06-19 12:45:55 |
| 7944 | 4064 | 3 | 2017-06-19 12:48:38 |
| 7945 | 4063 | 2 | 2017-06-19 13:57:33 |
| 7946 | 4057 | 2 | 2017-06-21 10:15:51 |
| 7947 | 4068 | 2 | 2017-06-21 10:17:48 |
| 7948 | 4066 | 2 | 2017-06-21 10:20:13 |
| 7949 | 4067 | 2 | 2017-06-21 10:30:11 |
| 7950 | 4069 | 2 | 2017-06-21 11:08:01 |
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;