Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,801–6,825 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6801 | 3566 | 2 | 2017-03-11 11:55:15 |
| 6802 | 3567 | 2 | 2017-03-11 11:59:18 |
| 6803 | 3564 | 2 | 2017-03-11 12:04:13 |
| 6804 | 3565 | 1 | 2017-03-11 12:21:02 |
| 6805 | 3564 | 1 | 2017-03-11 12:29:54 |
| 6806 | 3565 | 2 | 2017-03-11 12:53:04 |
| 6807 | 3567 | 3 | 2017-03-11 12:54:26 |
| 6808 | 3564 | 2 | 2017-03-11 12:57:45 |
| 6809 | 3566 | 1 | 2017-03-11 13:09:56 |
| 6810 | 3567 | 1 | 2017-03-11 13:23:04 |
| 6811 | 3567 | 2 | 2017-03-11 13:57:25 |
| 6812 | 3566 | 2 | 2017-03-11 14:11:05 |
| 6813 | 3609 | 2 | 2017-03-12 11:03:57 |
| 6814 | 3600 | 1 | 2017-03-13 09:51:12 |
| 6815 | 3599 | 2 | 2017-03-13 09:54:03 |
| 6816 | 3600 | 3 | 2017-03-13 10:22:24 |
| 6817 | 3599 | 3 | 2017-03-13 10:40:32 |
| 6818 | 3618 | 2 | 2017-03-14 10:05:10 |
| 6819 | 3353 | 2 | 2017-03-14 11:15:36 |
| 6820 | 3348 | 2 | 2017-03-14 11:15:39 |
| 6821 | 3345 | 2 | 2017-03-14 11:16:16 |
| 6822 | 3355 | 2 | 2017-03-14 11:16:17 |
| 6823 | 3358 | 2 | 2017-03-14 11:16:38 |
| 6824 | 3343 | 2 | 2017-03-14 11:17:47 |
| 6825 | 3350 | 2 | 2017-03-14 11:18: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;