Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,201–6,225 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6201 | 2978 | 1 | 2016-12-26 09:53:12 |
| 6202 | 2976 | 1 | 2016-12-26 09:54:12 |
| 6203 | 2971 | 1 | 2016-12-26 09:55:30 |
| 6204 | 2973 | 1 | 2016-12-26 09:55:36 |
| 6205 | 2977 | 1 | 2016-12-26 09:55:58 |
| 6206 | 2986 | 1 | 2016-12-26 09:56:32 |
| 6207 | 2964 | 1 | 2016-12-26 09:56:37 |
| 6208 | 2981 | 1 | 2016-12-26 09:57:59 |
| 6209 | 2960 | 1 | 2016-12-26 09:58:44 |
| 6210 | 2974 | 1 | 2016-12-26 09:59:22 |
| 6211 | 2975 | 1 | 2016-12-26 10:00:08 |
| 6212 | 2980 | 1 | 2016-12-26 10:01:43 |
| 6213 | 2957 | 1 | 2016-12-26 10:01:55 |
| 6214 | 2953 | 1 | 2016-12-26 10:04:21 |
| 6215 | 2965 | 1 | 2016-12-26 10:04:48 |
| 6216 | 2979 | 1 | 2016-12-26 10:05:15 |
| 6217 | 2963 | 1 | 2016-12-26 10:05:16 |
| 6218 | 2961 | 1 | 2016-12-26 10:05:18 |
| 6219 | 2982 | 1 | 2016-12-26 10:05:26 |
| 6220 | 2970 | 1 | 2016-12-26 10:05:31 |
| 6221 | 2959 | 1 | 2016-12-26 10:05:58 |
| 6222 | 2969 | 1 | 2016-12-26 10:06:05 |
| 6223 | 2985 | 1 | 2016-12-26 10:06:08 |
| 6224 | 2984 | 1 | 2016-12-26 10:06:27 |
| 6225 | 2989 | 1 | 2016-12-26 10:06:36 |
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;