Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,626–17,650 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17626 | 8834 | 3 | 2019-09-11 10:59:49 |
| 17627 | 8862 | 2 | 2019-09-11 12:03:55 |
| 17628 | 8860 | 2 | 2019-09-11 12:03:57 |
| 17629 | 8859 | 2 | 2019-09-11 12:11:12 |
| 17630 | 8863 | 3 | 2019-09-11 12:14:00 |
| 17631 | 8861 | 2 | 2019-09-11 12:15:39 |
| 17632 | 8729 | 2 | 2019-09-11 12:23:45 |
| 17633 | 8730 | 2 | 2019-09-11 12:28:22 |
| 17634 | 8859 | 3 | 2019-09-11 12:49:26 |
| 17635 | 8862 | 3 | 2019-09-11 12:57:33 |
| 17636 | 8860 | 3 | 2019-09-11 13:03:59 |
| 17637 | 8863 | 2 | 2019-09-11 13:15:11 |
| 17638 | 8861 | 3 | 2019-09-11 13:41:31 |
| 17639 | 8845 | 2 | 2019-09-11 14:17:47 |
| 17640 | 9010 | 1 | 2019-09-12 09:30:47 |
| 17641 | 9009 | 2 | 2019-09-12 09:38:32 |
| 17642 | 9009 | 1 | 2019-09-12 10:12:06 |
| 17643 | 8949 | 2 | 2019-09-12 10:24:17 |
| 17644 | 8949 | 3 | 2019-09-12 10:56:39 |
| 17645 | 9009 | 2 | 2019-09-12 11:41:18 |
| 17646 | 9009 | 1 | 2019-09-12 12:47:45 |
| 17647 | 9009 | 3 | 2019-09-12 13:54:45 |
| 17648 | 8955 | 1 | 2019-09-13 11:33:07 |
| 17649 | 8954 | 1 | 2019-09-13 11:34:55 |
| 17650 | 8953 | 1 | 2019-09-13 11:39:51 |
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;