Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,876–2,900 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2876 | 1389 | 1 | 2015-12-07 13:59:49 |
| 2877 | 1393 | 1 | 2015-12-07 14:00:44 |
| 2878 | 1567 | 2 | 2015-12-08 10:39:53 |
| 2879 | 1212 | 1 | 2015-12-08 12:29:21 |
| 2880 | 1208 | 1 | 2015-12-08 12:29:40 |
| 2881 | 1232 | 1 | 2015-12-08 12:30:23 |
| 2882 | 1247 | 1 | 2015-12-08 12:31:03 |
| 2883 | 1205 | 1 | 2015-12-08 12:31:17 |
| 2884 | 1210 | 1 | 2015-12-08 12:31:40 |
| 2885 | 1238 | 1 | 2015-12-08 12:33:11 |
| 2886 | 1211 | 1 | 2015-12-08 12:33:19 |
| 2887 | 1228 | 1 | 2015-12-08 12:34:03 |
| 2888 | 1229 | 1 | 2015-12-08 12:34:06 |
| 2889 | 1237 | 1 | 2015-12-08 12:34:33 |
| 2890 | 1234 | 1 | 2015-12-08 12:34:59 |
| 2891 | 1230 | 1 | 2015-12-08 12:36:00 |
| 2892 | 1252 | 1 | 2015-12-08 12:36:04 |
| 2893 | 1241 | 1 | 2015-12-08 12:36:27 |
| 2894 | 1235 | 1 | 2015-12-08 12:36:33 |
| 2895 | 1209 | 1 | 2015-12-08 12:37:25 |
| 2896 | 1236 | 1 | 2015-12-08 12:37:28 |
| 2897 | 1222 | 1 | 2015-12-08 12:37:42 |
| 2898 | 1204 | 1 | 2015-12-08 12:39:17 |
| 2899 | 1242 | 1 | 2015-12-08 12:39:32 |
| 2900 | 1220 | 1 | 2015-12-08 12:40:17 |
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;