Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,326–4,350 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4326 | 2303 | 1 | 2016-05-29 13:04:44 |
| 4327 | 2204 | 3 | 2016-05-29 13:13:07 |
| 4328 | 2203 | 3 | 2016-05-29 13:26:04 |
| 4329 | 2202 | 1 | 2016-05-29 13:26:43 |
| 4330 | 2303 | 3 | 2016-05-29 13:54:46 |
| 4331 | 2204 | 1 | 2016-05-29 14:26:16 |
| 4332 | 2203 | 1 | 2016-05-29 14:51:02 |
| 4333 | 2286 | 2 | 2016-05-29 14:53:20 |
| 4334 | 2285 | 2 | 2016-05-29 15:01:00 |
| 4335 | 2286 | 3 | 2016-05-29 15:27:06 |
| 4336 | 2305 | 2 | 2016-05-29 15:54:58 |
| 4337 | 2204 | 2 | 2016-05-29 15:58:07 |
| 4338 | 2304 | 2 | 2016-05-29 15:59:09 |
| 4339 | 2306 | 2 | 2016-05-29 16:00:06 |
| 4340 | 2304 | 1 | 2016-05-29 16:28:40 |
| 4341 | 2306 | 1 | 2016-05-29 17:05:42 |
| 4342 | 2305 | 1 | 2016-05-29 17:28:33 |
| 4343 | 2311 | 1 | 2016-06-01 10:22:55 |
| 4344 | 2312 | 1 | 2016-06-01 10:27:24 |
| 4345 | 2314 | 3 | 2016-06-01 14:22:00 |
| 4346 | 2315 | 3 | 2016-06-01 14:24:35 |
| 4347 | 2313 | 3 | 2016-06-01 14:29:39 |
| 4348 | 2317 | 2 | 2016-06-01 14:32:25 |
| 4349 | 2316 | 3 | 2016-06-01 14:38:11 |
| 4350 | 2316 | 2 | 2016-06-01 15:56: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;