Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,926–5,950 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5926 | 3019 | 2 | 2016-11-13 15:49:43 |
| 5927 | 3022 | 3 | 2016-11-14 11:01:06 |
| 5928 | 3021 | 3 | 2016-11-14 11:01:33 |
| 5929 | 3020 | 3 | 2016-11-14 11:11:14 |
| 5930 | 3021 | 2 | 2016-11-14 11:37:04 |
| 5931 | 2998 | 3 | 2016-11-14 12:15:37 |
| 5932 | 2999 | 3 | 2016-11-14 12:18:32 |
| 5933 | 3022 | 2 | 2016-11-14 12:33:52 |
| 5934 | 3020 | 2 | 2016-11-14 12:41:34 |
| 5935 | 3021 | 1 | 2016-11-14 12:55:19 |
| 5936 | 2999 | 1 | 2016-11-14 13:09:07 |
| 5937 | 3022 | 1 | 2016-11-14 14:05:45 |
| 5938 | 2999 | 3 | 2016-11-14 14:37:31 |
| 5939 | 3023 | 1 | 2016-11-15 16:03:43 |
| 5940 | 3024 | 1 | 2016-11-15 16:16:20 |
| 5941 | 3023 | 3 | 2016-11-15 16:52:27 |
| 5942 | 3024 | 3 | 2016-11-15 17:28:54 |
| 5943 | 3011 | 3 | 2016-11-17 11:20:51 |
| 5944 | 3025 | 1 | 2016-11-17 11:24:53 |
| 5945 | 3026 | 2 | 2016-11-17 11:25:10 |
| 5946 | 3027 | 2 | 2016-11-17 11:25:12 |
| 5947 | 3026 | 3 | 2016-11-17 12:09:56 |
| 5948 | 3026 | 2 | 2016-11-17 12:45:47 |
| 5949 | 3025 | 2 | 2016-11-17 12:50:31 |
| 5950 | 3027 | 3 | 2016-11-17 12:52:27 |
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;