Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,326–18,350 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18326 | 9363 | 2 | 2019-11-16 13:20:59 |
| 18327 | 9416 | 2 | 2019-11-16 14:05:10 |
| 18328 | 9415 | 1 | 2019-11-16 14:11:34 |
| 18329 | 9416 | 1 | 2019-11-16 15:10:24 |
| 18330 | 9420 | 2 | 2019-11-17 10:10:53 |
| 18331 | 9419 | 3 | 2019-11-17 10:14:19 |
| 18332 | 9420 | 3 | 2019-11-17 11:17:43 |
| 18333 | 9408 | 2 | 2019-11-17 11:53:25 |
| 18334 | 9409 | 2 | 2019-11-17 11:57:31 |
| 18335 | 9420 | 1 | 2019-11-17 12:15:22 |
| 18336 | 9408 | 3 | 2019-11-17 12:45:10 |
| 18337 | 9409 | 3 | 2019-11-17 13:02:48 |
| 18338 | 9409 | 1 | 2019-11-17 13:33:36 |
| 18339 | 9181 | 2 | 2019-11-17 14:22:37 |
| 18340 | 9180 | 2 | 2019-11-17 14:23:44 |
| 18341 | 9181 | 3 | 2019-11-17 14:50:25 |
| 18342 | 9180 | 3 | 2019-11-17 14:51:55 |
| 18343 | 9403 | 1 | 2019-11-18 13:48:14 |
| 18344 | 9403 | 2 | 2019-11-18 14:43:41 |
| 18345 | 9424 | 2 | 2019-11-19 10:10:30 |
| 18346 | 9421 | 3 | 2019-11-19 10:14:42 |
| 18347 | 9425 | 2 | 2019-11-19 10:17:09 |
| 18348 | 9422 | 2 | 2019-11-19 10:24:17 |
| 18349 | 9424 | 3 | 2019-11-19 10:57:46 |
| 18350 | 9425 | 3 | 2019-11-19 11:31:34 |
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;