Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,351–14,375 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14351 | 6633 | 1 | 2018-12-24 10:50:16 |
| 14352 | 6663 | 1 | 2018-12-24 10:51:00 |
| 14353 | 6660 | 1 | 2018-12-24 10:51:05 |
| 14354 | 6659 | 1 | 2018-12-24 10:51:42 |
| 14355 | 6662 | 1 | 2018-12-24 10:52:06 |
| 14356 | 6676 | 1 | 2018-12-24 10:52:09 |
| 14357 | 6648 | 1 | 2018-12-24 10:52:42 |
| 14358 | 6683 | 1 | 2018-12-24 10:52:49 |
| 14359 | 6680 | 1 | 2018-12-24 10:52:57 |
| 14360 | 6657 | 1 | 2018-12-24 10:53:15 |
| 14361 | 6674 | 1 | 2018-12-24 10:55:07 |
| 14362 | 6677 | 1 | 2018-12-24 10:55:07 |
| 14363 | 6658 | 1 | 2018-12-24 10:57:06 |
| 14364 | 7329 | 3 | 2018-12-24 11:31:57 |
| 14365 | 7329 | 1 | 2018-12-24 12:32:05 |
| 14366 | 7334 | 2 | 2018-12-25 14:41:02 |
| 14367 | 7332 | 2 | 2018-12-25 14:41:53 |
| 14368 | 7333 | 2 | 2018-12-25 14:44:00 |
| 14369 | 7334 | 3 | 2018-12-25 15:24:12 |
| 14370 | 7333 | 3 | 2018-12-25 15:45:33 |
| 14371 | 7332 | 3 | 2018-12-25 16:14:25 |
| 14372 | 7334 | 2 | 2018-12-25 16:16:38 |
| 14373 | 7333 | 2 | 2018-12-25 16:35:24 |
| 14374 | 7332 | 2 | 2018-12-25 16:43:41 |
| 14375 | 7350 | 3 | 2018-12-26 10:44: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;