Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,351–2,375 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2351 | 1334 | 2 | 2015-10-18 14:48:24 |
| 2352 | 1335 | 1 | 2015-10-18 15:18:16 |
| 2353 | 1334 | 3 | 2015-10-18 15:42:09 |
| 2354 | 1334 | 1 | 2015-10-18 16:43:31 |
| 2355 | 1339 | 2 | 2015-10-19 12:25:28 |
| 2356 | 1340 | 2 | 2015-10-19 12:25:34 |
| 2357 | 1339 | 3 | 2015-10-19 13:01:39 |
| 2358 | 1340 | 3 | 2015-10-19 13:16:40 |
| 2359 | 1337 | 2 | 2015-10-19 16:53:03 |
| 2360 | 1336 | 2 | 2015-10-19 17:00:01 |
| 2361 | 1338 | 2 | 2015-10-19 17:05:05 |
| 2362 | 1344 | 1 | 2015-10-20 15:19:22 |
| 2363 | 1344 | 2 | 2015-10-20 16:03:41 |
| 2364 | 1344 | 3 | 2015-10-20 16:32:26 |
| 2365 | 1307 | 1 | 2015-10-21 14:41:16 |
| 2366 | 1308 | 1 | 2015-10-21 14:42:31 |
| 2367 | 1345 | 2 | 2015-10-22 10:51:12 |
| 2368 | 1345 | 3 | 2015-10-22 12:07:51 |
| 2369 | 1345 | 1 | 2015-10-22 12:52:48 |
| 2370 | 1345 | 2 | 2015-10-22 14:18:17 |
| 2371 | 1347 | 1 | 2015-10-23 11:10:52 |
| 2372 | 1348 | 1 | 2015-10-23 11:11:32 |
| 2373 | 1346 | 1 | 2015-10-23 11:11:51 |
| 2374 | 1349 | 1 | 2015-10-23 11:14:47 |
| 2375 | 1347 | 3 | 2015-10-23 11:45:04 |
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;