Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,276–2,300 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2276 | 1124 | 2 | 2015-10-13 13:44:39 |
| 2277 | 1102 | 2 | 2015-10-13 13:45:39 |
| 2278 | 1116 | 2 | 2015-10-13 13:45:46 |
| 2279 | 1316 | 2 | 2015-10-13 13:45:49 |
| 2280 | 1120 | 2 | 2015-10-13 13:45:53 |
| 2281 | 1118 | 2 | 2015-10-13 13:46:56 |
| 2282 | 1114 | 2 | 2015-10-13 13:47:50 |
| 2283 | 1115 | 2 | 2015-10-13 13:50:09 |
| 2284 | 1123 | 2 | 2015-10-13 13:51:05 |
| 2285 | 1278 | 2 | 2015-10-13 13:54:59 |
| 2286 | 1098 | 3 | 2015-10-13 14:00:59 |
| 2287 | 1125 | 3 | 2015-10-13 14:05:02 |
| 2288 | 1100 | 3 | 2015-10-13 14:06:11 |
| 2289 | 1103 | 3 | 2015-10-13 14:10:08 |
| 2290 | 1112 | 3 | 2015-10-13 14:10:30 |
| 2291 | 1110 | 3 | 2015-10-13 14:12:16 |
| 2292 | 1113 | 3 | 2015-10-13 14:13:21 |
| 2293 | 1111 | 3 | 2015-10-13 14:14:30 |
| 2294 | 1097 | 3 | 2015-10-13 14:15:26 |
| 2295 | 1093 | 3 | 2015-10-13 14:16:29 |
| 2296 | 1122 | 3 | 2015-10-13 14:17:14 |
| 2297 | 1104 | 3 | 2015-10-13 14:17:32 |
| 2298 | 1105 | 3 | 2015-10-13 14:20:36 |
| 2299 | 1092 | 3 | 2015-10-13 14:22:34 |
| 2300 | 1120 | 3 | 2015-10-13 14:23:46 |
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;