Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,326–6,350 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6326 | 3250 | 3 | 2017-01-05 09:46:41 |
| 6327 | 3249 | 3 | 2017-01-05 09:55:56 |
| 6328 | 3250 | 2 | 2017-01-05 10:21:42 |
| 6329 | 3248 | 2 | 2017-01-05 10:38:11 |
| 6330 | 3341 | 2 | 2017-01-05 11:09:22 |
| 6331 | 3249 | 2 | 2017-01-05 11:14:40 |
| 6332 | 3341 | 3 | 2017-01-05 11:36:22 |
| 6333 | 3384 | 1 | 2017-01-06 10:42:33 |
| 6334 | 3383 | 1 | 2017-01-06 10:45:21 |
| 6335 | 3320 | 2 | 2017-01-06 10:55:55 |
| 6336 | 3321 | 2 | 2017-01-06 11:04:20 |
| 6337 | 3383 | 3 | 2017-01-06 11:21:24 |
| 6338 | 3320 | 3 | 2017-01-06 11:25:50 |
| 6339 | 3384 | 3 | 2017-01-06 11:28:40 |
| 6340 | 3321 | 3 | 2017-01-06 11:35:45 |
| 6341 | 3320 | 1 | 2017-01-06 11:58:40 |
| 6342 | 3383 | 2 | 2017-01-06 12:11:07 |
| 6343 | 3321 | 1 | 2017-01-06 12:25:22 |
| 6344 | 3384 | 2 | 2017-01-06 12:31:07 |
| 6345 | 3335 | 1 | 2017-01-07 09:33:55 |
| 6346 | 3335 | 2 | 2017-01-07 10:37:31 |
| 6347 | 3340 | 3 | 2017-01-07 11:16:51 |
| 6348 | 3340 | 2 | 2017-01-07 11:50:18 |
| 6349 | 3387 | 2 | 2017-01-07 12:09:21 |
| 6350 | 3385 | 3 | 2017-01-07 12:11:32 |
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;