Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,051–8,075 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8051 | 3647 | 3 | 2017-07-02 10:11:17 |
| 8052 | 3637 | 3 | 2017-07-02 10:11:50 |
| 8053 | 3649 | 3 | 2017-07-02 10:12:41 |
| 8054 | 3640 | 3 | 2017-07-02 10:12:42 |
| 8055 | 3662 | 3 | 2017-07-02 10:13:45 |
| 8056 | 3638 | 3 | 2017-07-02 10:14:35 |
| 8057 | 3664 | 3 | 2017-07-02 10:17:02 |
| 8058 | 3639 | 3 | 2017-07-02 10:17:57 |
| 8059 | 3656 | 3 | 2017-07-02 10:18:28 |
| 8060 | 3659 | 3 | 2017-07-02 10:18:42 |
| 8061 | 3648 | 3 | 2017-07-02 10:19:02 |
| 8062 | 3663 | 3 | 2017-07-02 10:19:03 |
| 8063 | 3666 | 3 | 2017-07-02 10:19:34 |
| 8064 | 3657 | 3 | 2017-07-02 10:19:39 |
| 8065 | 3673 | 3 | 2017-07-02 10:19:42 |
| 8066 | 3645 | 3 | 2017-07-02 10:20:17 |
| 8067 | 3665 | 3 | 2017-07-02 10:20:17 |
| 8068 | 3669 | 3 | 2017-07-02 10:20:27 |
| 8069 | 3680 | 3 | 2017-07-02 10:20:45 |
| 8070 | 3670 | 3 | 2017-07-02 10:21:02 |
| 8071 | 3661 | 3 | 2017-07-02 10:21:18 |
| 8072 | 3676 | 3 | 2017-07-02 10:21:24 |
| 8073 | 3651 | 3 | 2017-07-02 10:21:25 |
| 8074 | 3671 | 3 | 2017-07-02 10:21:30 |
| 8075 | 3653 | 3 | 2017-07-02 10:21:50 |
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;