Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,751–6,775 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6751 | 3525 | 1 | 2017-03-05 10:13:51 |
| 6752 | 3587 | 2 | 2017-03-05 11:05:09 |
| 6753 | 3592 | 2 | 2017-03-05 11:09:00 |
| 6754 | 3588 | 2 | 2017-03-05 11:10:49 |
| 6755 | 3593 | 2 | 2017-03-05 11:11:43 |
| 6756 | 3589 | 2 | 2017-03-05 11:14:19 |
| 6757 | 3587 | 3 | 2017-03-05 11:40:05 |
| 6758 | 3589 | 3 | 2017-03-05 11:40:05 |
| 6759 | 3588 | 3 | 2017-03-05 12:31:58 |
| 6760 | 3590 | 2 | 2017-03-06 09:53:49 |
| 6761 | 3590 | 1 | 2017-03-06 10:29:11 |
| 6762 | 3595 | 3 | 2017-03-06 11:16:46 |
| 6763 | 3597 | 3 | 2017-03-06 11:24:07 |
| 6764 | 3598 | 3 | 2017-03-06 11:24:46 |
| 6765 | 3596 | 3 | 2017-03-06 11:30:38 |
| 6766 | 3601 | 2 | 2017-03-07 10:27:41 |
| 6767 | 3602 | 2 | 2017-03-07 10:29:43 |
| 6768 | 3601 | 1 | 2017-03-07 11:57:14 |
| 6769 | 3603 | 1 | 2017-03-07 13:11:09 |
| 6770 | 3604 | 2 | 2017-03-07 13:11:30 |
| 6771 | 3604 | 3 | 2017-03-07 14:24:30 |
| 6772 | 3606 | 3 | 2017-03-08 09:22:51 |
| 6773 | 3605 | 3 | 2017-03-08 09:36:40 |
| 6774 | 3582 | 2 | 2017-03-08 10:05:54 |
| 6775 | 3605 | 2 | 2017-03-08 10:10:28 |
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;