Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,801–9,825 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9801 | 5034 | 1 | 2017-12-28 16:05:48 |
| 9802 | 4972 | 1 | 2017-12-30 12:06:39 |
| 9803 | 4973 | 1 | 2017-12-30 12:08:31 |
| 9804 | 4973 | 2 | 2017-12-30 12:37:49 |
| 9805 | 4972 | 2 | 2017-12-30 13:34:16 |
| 9806 | 4992 | 1 | 2017-12-31 12:04:43 |
| 9807 | 4992 | 2 | 2017-12-31 12:35:28 |
| 9808 | 4992 | 1 | 2017-12-31 13:30:03 |
| 9809 | 5039 | 2 | 2018-01-01 12:16:26 |
| 9810 | 5038 | 2 | 2018-01-01 13:17:43 |
| 9811 | 5039 | 3 | 2018-01-01 13:50:42 |
| 9812 | 5038 | 3 | 2018-01-01 14:52:46 |
| 9813 | 5038 | 1 | 2018-01-01 16:10:56 |
| 9814 | 5043 | 1 | 2018-01-02 10:31:19 |
| 9815 | 5042 | 1 | 2018-01-02 10:33:29 |
| 9816 | 5042 | 3 | 2018-01-02 11:53:45 |
| 9817 | 5043 | 3 | 2018-01-02 11:59:04 |
| 9818 | 5045 | 2 | 2018-01-03 16:03:51 |
| 9819 | 5057 | 2 | 2018-01-05 12:08:05 |
| 9820 | 5059 | 2 | 2018-01-05 12:13:03 |
| 9821 | 5058 | 2 | 2018-01-05 12:18:25 |
| 9822 | 5057 | 1 | 2018-01-05 13:17:45 |
| 9823 | 5058 | 1 | 2018-01-05 13:20:14 |
| 9824 | 5059 | 1 | 2018-01-05 13:44:33 |
| 9825 | 5057 | 3 | 2018-01-05 14:01:25 |
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;