Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,476–18,500 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18476 | 9471 | 1 | 2019-11-28 17:18:19 |
| 18477 | 9473 | 1 | 2019-11-28 17:23:10 |
| 18478 | 9470 | 1 | 2019-11-28 17:39:30 |
| 18479 | 9438 | 2 | 2019-11-29 12:52:00 |
| 18480 | 9437 | 2 | 2019-11-29 12:52:14 |
| 18481 | 9438 | 3 | 2019-11-29 14:09:13 |
| 18482 | 9438 | 1 | 2019-11-29 15:11:11 |
| 18483 | 9485 | 1 | 2019-11-30 10:10:26 |
| 18484 | 9486 | 3 | 2019-11-30 10:14:37 |
| 18485 | 9484 | 1 | 2019-11-30 10:21:03 |
| 18486 | 9484 | 3 | 2019-11-30 10:49:56 |
| 18487 | 9486 | 2 | 2019-11-30 10:57:51 |
| 18488 | 9485 | 3 | 2019-11-30 11:25:59 |
| 18489 | 9484 | 2 | 2019-11-30 11:49:49 |
| 18490 | 9486 | 3 | 2019-11-30 12:31:00 |
| 18491 | 9485 | 2 | 2019-11-30 12:54:44 |
| 18492 | 9487 | 1 | 2019-11-30 16:54:12 |
| 18493 | 9487 | 2 | 2019-11-30 17:37:50 |
| 18494 | 9478 | 2 | 2019-12-01 14:02:09 |
| 18495 | 9493 | 3 | 2019-12-01 14:28:21 |
| 18496 | 9412 | 2 | 2019-12-01 15:07:26 |
| 18497 | 9478 | 1 | 2019-12-01 15:07:42 |
| 18498 | 9493 | 1 | 2019-12-01 15:49:38 |
| 18499 | 9493 | 3 | 2019-12-01 16:17:29 |
| 18500 | 9492 | 1 | 2019-12-01 17:07: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;