Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,476–9,500 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9476 | 4700 | 2 | 2017-11-22 12:23:16 |
| 9477 | 4716 | 2 | 2017-11-22 12:23:18 |
| 9478 | 4685 | 2 | 2017-11-22 12:24:07 |
| 9479 | 4705 | 2 | 2017-11-22 12:24:33 |
| 9480 | 4737 | 2 | 2017-11-22 12:24:40 |
| 9481 | 4718 | 2 | 2017-11-22 12:26:01 |
| 9482 | 4691 | 2 | 2017-11-22 12:26:11 |
| 9483 | 4714 | 2 | 2017-11-22 12:26:35 |
| 9484 | 4697 | 2 | 2017-11-22 12:26:48 |
| 9485 | 4702 | 2 | 2017-11-22 12:26:48 |
| 9486 | 4721 | 2 | 2017-11-22 12:26:50 |
| 9487 | 4726 | 2 | 2017-11-22 12:27:15 |
| 9488 | 4688 | 2 | 2017-11-22 12:27:28 |
| 9489 | 4720 | 2 | 2017-11-22 12:27:28 |
| 9490 | 4727 | 2 | 2017-11-22 12:27:57 |
| 9491 | 4692 | 2 | 2017-11-22 12:28:35 |
| 9492 | 4731 | 2 | 2017-11-22 12:28:54 |
| 9493 | 4715 | 2 | 2017-11-22 12:28:56 |
| 9494 | 4696 | 2 | 2017-11-22 12:29:00 |
| 9495 | 4704 | 2 | 2017-11-22 12:29:09 |
| 9496 | 4734 | 2 | 2017-11-22 12:29:22 |
| 9497 | 4686 | 2 | 2017-11-22 12:29:25 |
| 9498 | 4695 | 2 | 2017-11-22 12:29:31 |
| 9499 | 4724 | 2 | 2017-11-22 12:29:32 |
| 9500 | 4711 | 2 | 2017-11-22 12:31:40 |
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;