Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,751–7,775 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7751 | 4018 | 3 | 2017-06-10 11:34:58 |
| 7752 | 4018 | 2 | 2017-06-10 12:11:58 |
| 7753 | 4018 | 3 | 2017-06-10 13:09:39 |
| 7754 | 4028 | 2 | 2017-06-11 09:17:10 |
| 7755 | 4027 | 2 | 2017-06-11 09:19:50 |
| 7756 | 4026 | 2 | 2017-06-11 09:21:42 |
| 7757 | 4025 | 2 | 2017-06-11 09:24:39 |
| 7758 | 4025 | 1 | 2017-06-11 09:53:02 |
| 7759 | 4026 | 1 | 2017-06-11 09:53:13 |
| 7760 | 4027 | 1 | 2017-06-11 09:56:34 |
| 7761 | 4026 | 2 | 2017-06-11 10:21:38 |
| 7762 | 4027 | 3 | 2017-06-11 10:30:44 |
| 7763 | 4028 | 1 | 2017-06-11 10:33:11 |
| 7764 | 4028 | 3 | 2017-06-11 11:01:07 |
| 7765 | 4025 | 3 | 2017-06-11 11:17:27 |
| 7766 | 4030 | 3 | 2017-06-11 11:59:30 |
| 7767 | 4029 | 3 | 2017-06-11 12:02:53 |
| 7768 | 4030 | 2 | 2017-06-11 12:45:19 |
| 7769 | 4029 | 2 | 2017-06-11 13:12:50 |
| 7770 | 4033 | 1 | 2017-06-11 13:20:50 |
| 7771 | 4032 | 2 | 2017-06-11 13:21:16 |
| 7772 | 4034 | 1 | 2017-06-11 13:33:39 |
| 7773 | 4031 | 2 | 2017-06-11 13:33:49 |
| 7774 | 4037 | 3 | 2017-06-11 13:39:18 |
| 7775 | 4036 | 1 | 2017-06-11 13:39:44 |
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;