Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,301–4,325 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4301 | 2148 | 3 | 2016-05-29 12:20:24 |
| 4302 | 2203 | 2 | 2016-05-29 12:20:25 |
| 4303 | 2204 | 2 | 2016-05-29 12:20:29 |
| 4304 | 2190 | 3 | 2016-05-29 12:21:58 |
| 4305 | 2189 | 3 | 2016-05-29 12:22:47 |
| 4306 | 2202 | 2 | 2016-05-29 12:22:50 |
| 4307 | 2182 | 3 | 2016-05-29 12:23:59 |
| 4308 | 2149 | 3 | 2016-05-29 12:24:14 |
| 4309 | 2156 | 3 | 2016-05-29 12:24:32 |
| 4310 | 2183 | 3 | 2016-05-29 12:24:36 |
| 4311 | 2191 | 3 | 2016-05-29 12:24:52 |
| 4312 | 2176 | 3 | 2016-05-29 12:24:53 |
| 4313 | 2169 | 3 | 2016-05-29 12:25:50 |
| 4314 | 2153 | 3 | 2016-05-29 12:26:42 |
| 4315 | 2197 | 3 | 2016-05-29 12:27:02 |
| 4316 | 2196 | 3 | 2016-05-29 12:27:26 |
| 4317 | 2170 | 3 | 2016-05-29 12:27:37 |
| 4318 | 2187 | 3 | 2016-05-29 12:27:54 |
| 4319 | 2164 | 3 | 2016-05-29 12:28:45 |
| 4320 | 2166 | 3 | 2016-05-29 12:29:29 |
| 4321 | 2185 | 3 | 2016-05-29 12:29:43 |
| 4322 | 2180 | 3 | 2016-05-29 12:30:32 |
| 4323 | 2194 | 3 | 2016-05-29 12:30:40 |
| 4324 | 2179 | 3 | 2016-05-29 12:31:53 |
| 4325 | 2302 | 1 | 2016-05-29 13:01:07 |
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;