Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,651–5,675 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5651 | 2879 | 3 | 2016-10-10 14:21:17 |
| 5652 | 2881 | 3 | 2016-10-10 14:37:32 |
| 5653 | 2903 | 2 | 2016-10-11 10:45:12 |
| 5654 | 2905 | 2 | 2016-10-11 10:47:32 |
| 5655 | 2902 | 2 | 2016-10-11 10:49:43 |
| 5656 | 2904 | 2 | 2016-10-11 10:54:39 |
| 5657 | 2903 | 3 | 2016-10-11 11:29:36 |
| 5658 | 2902 | 3 | 2016-10-11 11:33:54 |
| 5659 | 2905 | 3 | 2016-10-11 12:09:45 |
| 5660 | 2904 | 3 | 2016-10-11 12:19:48 |
| 5661 | 2856 | 3 | 2016-10-12 10:15:13 |
| 5662 | 2857 | 3 | 2016-10-12 10:19:47 |
| 5663 | 2817 | 2 | 2016-10-12 11:40:20 |
| 5664 | 2816 | 2 | 2016-10-12 11:42:38 |
| 5665 | 2817 | 1 | 2016-10-12 12:06:08 |
| 5666 | 2816 | 1 | 2016-10-12 12:17:34 |
| 5667 | 2908 | 1 | 2016-10-12 16:09:12 |
| 5668 | 2907 | 1 | 2016-10-12 16:14:13 |
| 5669 | 2906 | 1 | 2016-10-12 16:23:09 |
| 5670 | 2906 | 2 | 2016-10-12 17:01:29 |
| 5671 | 2908 | 2 | 2016-10-12 17:06:56 |
| 5672 | 2907 | 2 | 2016-10-12 17:33:38 |
| 5673 | 2846 | 1 | 2016-10-13 11:12:35 |
| 5674 | 2847 | 1 | 2016-10-13 11:16:14 |
| 5675 | 2846 | 2 | 2016-10-13 12:07:24 |
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;