Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,976–3,000 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2976 | 1242 | 3 | 2015-12-08 14:52:17 |
| 2977 | 1243 | 3 | 2015-12-08 14:55:42 |
| 2978 | 1236 | 3 | 2015-12-08 15:02:51 |
| 2979 | 1244 | 2 | 2015-12-08 15:06:51 |
| 2980 | 1249 | 3 | 2015-12-08 15:09:35 |
| 2981 | 1220 | 3 | 2015-12-08 15:12:29 |
| 2982 | 1207 | 2 | 2015-12-08 15:13:32 |
| 2983 | 1228 | 3 | 2015-12-08 15:13:53 |
| 2984 | 1246 | 2 | 2015-12-08 15:16:25 |
| 2985 | 1206 | 1 | 2015-12-08 15:18:08 |
| 2986 | 1245 | 3 | 2015-12-08 15:19:07 |
| 2987 | 1209 | 3 | 2015-12-08 15:20:49 |
| 2988 | 1230 | 2 | 2015-12-08 15:20:49 |
| 2989 | 1212 | 1 | 2015-12-08 15:22:58 |
| 2990 | 1221 | 2 | 2015-12-08 15:24:16 |
| 2991 | 1211 | 3 | 2015-12-08 15:24:18 |
| 2992 | 1237 | 3 | 2015-12-08 15:25:18 |
| 2993 | 1232 | 2 | 2015-12-08 15:26:09 |
| 2994 | 1235 | 2 | 2015-12-08 15:27:18 |
| 2995 | 1252 | 2 | 2015-12-08 15:27:54 |
| 2996 | 1205 | 2 | 2015-12-08 15:28:19 |
| 2997 | 1227 | 3 | 2015-12-08 15:30:17 |
| 2998 | 1204 | 3 | 2015-12-08 15:31:38 |
| 2999 | 1238 | 1 | 2015-12-08 15:32:46 |
| 3000 | 1222 | 2 | 2015-12-08 15:36:15 |
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;