Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,651–9,675 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9651 | 4865 | 1 | 2017-12-09 13:11:44 |
| 9652 | 4863 | 2 | 2017-12-09 13:41:15 |
| 9653 | 4864 | 2 | 2017-12-09 13:59:56 |
| 9654 | 4865 | 2 | 2017-12-09 14:03:03 |
| 9655 | 4906 | 2 | 2017-12-10 11:04:19 |
| 9656 | 4906 | 1 | 2017-12-10 11:51:14 |
| 9657 | 4906 | 3 | 2017-12-10 13:22:15 |
| 9658 | 4924 | 2 | 2017-12-10 14:51:16 |
| 9659 | 4924 | 1 | 2017-12-10 16:05:05 |
| 9660 | 4931 | 2 | 2017-12-10 16:30:35 |
| 9661 | 4929 | 2 | 2017-12-10 16:36:20 |
| 9662 | 4932 | 2 | 2017-12-10 16:43:31 |
| 9663 | 4930 | 2 | 2017-12-10 16:45:06 |
| 9664 | 4932 | 3 | 2017-12-10 17:14:07 |
| 9665 | 4929 | 3 | 2017-12-10 17:25:48 |
| 9666 | 4931 | 3 | 2017-12-10 17:30:04 |
| 9667 | 4925 | 2 | 2017-12-12 10:59:13 |
| 9668 | 4926 | 2 | 2017-12-12 11:02:29 |
| 9669 | 4927 | 2 | 2017-12-12 11:06:36 |
| 9670 | 4927 | 3 | 2017-12-12 12:18:16 |
| 9671 | 4925 | 3 | 2017-12-12 12:22:52 |
| 9672 | 4926 | 3 | 2017-12-12 12:35:22 |
| 9673 | 4938 | 3 | 2017-12-12 15:27:35 |
| 9674 | 4937 | 3 | 2017-12-12 15:33:35 |
| 9675 | 4936 | 1 | 2017-12-12 15:35:01 |
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;