Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,126–9,150 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9126 | 4777 | 2 | 2017-10-17 16:39:08 |
| 9127 | 4775 | 2 | 2017-10-17 16:39:57 |
| 9128 | 4775 | 1 | 2017-10-17 17:24:46 |
| 9129 | 4784 | 2 | 2017-10-18 14:57:15 |
| 9130 | 4783 | 2 | 2017-10-18 14:59:49 |
| 9131 | 4782 | 2 | 2017-10-18 14:59:59 |
| 9132 | 4782 | 1 | 2017-10-18 15:28:45 |
| 9133 | 4783 | 1 | 2017-10-18 15:44:35 |
| 9134 | 4784 | 1 | 2017-10-18 15:46:43 |
| 9135 | 4784 | 3 | 2017-10-18 16:25:58 |
| 9136 | 4782 | 3 | 2017-10-18 16:48:02 |
| 9137 | 4783 | 3 | 2017-10-18 16:48:28 |
| 9138 | 4796 | 2 | 2017-10-20 09:25:09 |
| 9139 | 4795 | 2 | 2017-10-20 09:26:39 |
| 9140 | 4796 | 3 | 2017-10-20 10:12:37 |
| 9141 | 4745 | 1 | 2017-10-20 16:16:11 |
| 9142 | 4745 | 3 | 2017-10-20 17:48:57 |
| 9143 | 4799 | 2 | 2017-10-21 09:25:43 |
| 9144 | 4774 | 2 | 2017-10-21 09:34:43 |
| 9145 | 4774 | 3 | 2017-10-21 10:37:22 |
| 9146 | 4774 | 1 | 2017-10-21 11:05:47 |
| 9147 | 4804 | 2 | 2017-10-21 14:48:27 |
| 9148 | 4806 | 2 | 2017-10-21 14:55:43 |
| 9149 | 4805 | 2 | 2017-10-21 14:57:29 |
| 9150 | 4805 | 3 | 2017-10-21 15:42:35 |
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;