Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,026–9,050 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9026 | 4658 | 3 | 2017-10-01 15:15:34 |
| 9027 | 4659 | 3 | 2017-10-01 15:17:57 |
| 9028 | 4658 | 2 | 2017-10-01 16:21:27 |
| 9029 | 4659 | 2 | 2017-10-01 16:34:25 |
| 9030 | 4742 | 3 | 2017-10-02 09:40:39 |
| 9031 | 4743 | 2 | 2017-10-02 10:50:27 |
| 9032 | 4744 | 2 | 2017-10-02 10:53:07 |
| 9033 | 4680 | 2 | 2017-10-05 16:09:19 |
| 9034 | 4682 | 3 | 2017-10-05 16:13:43 |
| 9035 | 4681 | 2 | 2017-10-05 16:19:52 |
| 9036 | 4680 | 3 | 2017-10-05 16:53:29 |
| 9037 | 4681 | 3 | 2017-10-05 17:07:03 |
| 9038 | 4682 | 2 | 2017-10-05 17:11:42 |
| 9039 | 4752 | 3 | 2017-10-07 11:01:09 |
| 9040 | 4757 | 2 | 2017-10-09 16:58:49 |
| 9041 | 4763 | 3 | 2017-10-10 09:30:46 |
| 9042 | 4762 | 3 | 2017-10-10 09:31:03 |
| 9043 | 4600 | 2 | 2017-10-10 09:43:11 |
| 9044 | 4602 | 2 | 2017-10-10 09:43:21 |
| 9045 | 4601 | 2 | 2017-10-10 09:44:10 |
| 9046 | 4598 | 2 | 2017-10-10 09:44:46 |
| 9047 | 4620 | 2 | 2017-10-10 09:45:39 |
| 9048 | 4606 | 2 | 2017-10-10 09:45:43 |
| 9049 | 4610 | 2 | 2017-10-10 09:45:45 |
| 9050 | 4611 | 2 | 2017-10-10 09:47:29 |
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;