Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,126–16,150 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16126 | 8259 | 2 | 2019-05-26 15:13:47 |
| 16127 | 8258 | 2 | 2019-05-26 15:17:08 |
| 16128 | 8257 | 2 | 2019-05-26 15:17:34 |
| 16129 | 8255 | 2 | 2019-05-26 15:17:51 |
| 16130 | 8256 | 3 | 2019-05-26 15:53:57 |
| 16131 | 8258 | 3 | 2019-05-26 16:05:22 |
| 16132 | 8255 | 3 | 2019-05-26 16:08:48 |
| 16133 | 8256 | 2 | 2019-05-26 16:49:35 |
| 16134 | 8258 | 2 | 2019-05-26 17:15:15 |
| 16135 | 8255 | 2 | 2019-05-26 17:36:10 |
| 16136 | 8274 | 1 | 2019-05-27 10:17:28 |
| 16137 | 8273 | 2 | 2019-05-27 10:18:18 |
| 16138 | 8274 | 3 | 2019-05-27 11:32:30 |
| 16139 | 8274 | 1 | 2019-05-27 12:58:30 |
| 16140 | 8242 | 2 | 2019-05-27 14:09:31 |
| 16141 | 8243 | 2 | 2019-05-27 14:11:53 |
| 16142 | 8287 | 2 | 2019-05-28 10:43:49 |
| 16143 | 8286 | 2 | 2019-05-28 10:46:51 |
| 16144 | 8288 | 2 | 2019-05-28 10:48:53 |
| 16145 | 8294 | 2 | 2019-05-28 13:47:00 |
| 16146 | 8293 | 2 | 2019-05-28 13:54:05 |
| 16147 | 8292 | 2 | 2019-05-28 13:54:15 |
| 16148 | 8254 | 1 | 2019-05-28 14:49:20 |
| 16149 | 8227 | 1 | 2019-05-28 15:07:35 |
| 16150 | 8294 | 3 | 2019-05-28 15:08:04 |
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;