Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,226–6,250 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6226 | 2968 | 1 | 2016-12-26 10:08:02 |
| 6227 | 2972 | 1 | 2016-12-26 10:08:43 |
| 6228 | 2987 | 1 | 2016-12-26 10:09:16 |
| 6229 | 2960 | 2 | 2016-12-26 10:31:07 |
| 6230 | 2959 | 2 | 2016-12-26 10:31:39 |
| 6231 | 2986 | 2 | 2016-12-26 10:32:23 |
| 6232 | 2973 | 2 | 2016-12-26 10:37:46 |
| 6233 | 2953 | 2 | 2016-12-26 10:38:45 |
| 6234 | 2978 | 2 | 2016-12-26 10:39:10 |
| 6235 | 2962 | 2 | 2016-12-26 10:41:15 |
| 6236 | 2975 | 2 | 2016-12-26 10:41:42 |
| 6237 | 2979 | 2 | 2016-12-26 10:45:41 |
| 6238 | 2967 | 2 | 2016-12-26 10:48:58 |
| 6239 | 2981 | 2 | 2016-12-26 10:49:31 |
| 6240 | 2969 | 2 | 2016-12-26 10:55:50 |
| 6241 | 2968 | 2 | 2016-12-26 10:58:33 |
| 6242 | 2972 | 2 | 2016-12-26 11:04:12 |
| 6243 | 2977 | 2 | 2016-12-26 11:04:55 |
| 6244 | 2987 | 2 | 2016-12-26 11:04:57 |
| 6245 | 2955 | 2 | 2016-12-26 11:05:44 |
| 6246 | 2971 | 2 | 2016-12-26 11:06:58 |
| 6247 | 2957 | 2 | 2016-12-26 11:11:18 |
| 6248 | 2964 | 2 | 2016-12-26 11:15:04 |
| 6249 | 2976 | 2 | 2016-12-26 11:16:48 |
| 6250 | 2974 | 2 | 2016-12-26 11:17:48 |
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;