Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,326–14,350 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14326 | 6675 | 1 | 2018-12-24 10:43:55 |
| 14327 | 6671 | 1 | 2018-12-24 10:43:56 |
| 14328 | 6664 | 1 | 2018-12-24 10:44:09 |
| 14329 | 6635 | 1 | 2018-12-24 10:44:17 |
| 14330 | 6646 | 1 | 2018-12-24 10:44:27 |
| 14331 | 6665 | 1 | 2018-12-24 10:44:27 |
| 14332 | 6678 | 1 | 2018-12-24 10:45:21 |
| 14333 | 6625 | 1 | 2018-12-24 10:45:34 |
| 14334 | 7267 | 2 | 2018-12-24 10:45:44 |
| 14335 | 6684 | 1 | 2018-12-24 10:46:01 |
| 14336 | 6645 | 1 | 2018-12-24 10:46:14 |
| 14337 | 6673 | 1 | 2018-12-24 10:46:18 |
| 14338 | 6642 | 1 | 2018-12-24 10:46:53 |
| 14339 | 6640 | 1 | 2018-12-24 10:46:55 |
| 14340 | 6654 | 1 | 2018-12-24 10:46:59 |
| 14341 | 6669 | 1 | 2018-12-24 10:47:14 |
| 14342 | 6632 | 1 | 2018-12-24 10:48:29 |
| 14343 | 6681 | 1 | 2018-12-24 10:48:50 |
| 14344 | 6672 | 1 | 2018-12-24 10:48:57 |
| 14345 | 6630 | 1 | 2018-12-24 10:48:59 |
| 14346 | 6644 | 1 | 2018-12-24 10:49:14 |
| 14347 | 6655 | 1 | 2018-12-24 10:49:39 |
| 14348 | 6638 | 1 | 2018-12-24 10:49:49 |
| 14349 | 6652 | 1 | 2018-12-24 10:49:55 |
| 14350 | 6656 | 1 | 2018-12-24 10:50: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;