Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,951–5,975 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5951 | 3027 | 2 | 2016-11-17 13:19:56 |
| 5952 | 3027 | 1 | 2016-11-17 13:52:53 |
| 5953 | 3026 | 1 | 2016-11-17 14:17:42 |
| 5954 | 3033 | 2 | 2016-11-20 10:04:17 |
| 5955 | 3031 | 2 | 2016-11-20 10:07:00 |
| 5956 | 3034 | 2 | 2016-11-20 10:10:58 |
| 5957 | 3032 | 2 | 2016-11-20 10:16:39 |
| 5958 | 3033 | 3 | 2016-11-20 10:32:19 |
| 5959 | 3032 | 3 | 2016-11-20 11:01:02 |
| 5960 | 3034 | 3 | 2016-11-20 11:06:03 |
| 5961 | 3033 | 1 | 2016-11-20 11:15:41 |
| 5962 | 3031 | 3 | 2016-11-20 11:30:56 |
| 5963 | 3032 | 1 | 2016-11-20 11:35:58 |
| 5964 | 3035 | 1 | 2016-11-20 11:55:12 |
| 5965 | 3031 | 1 | 2016-11-20 11:59:25 |
| 5966 | 3036 | 3 | 2016-11-20 12:02:52 |
| 5967 | 3034 | 1 | 2016-11-20 12:06:01 |
| 5968 | 3035 | 3 | 2016-11-20 12:28:39 |
| 5969 | 3035 | 1 | 2016-11-20 12:56:54 |
| 5970 | 3037 | 2 | 2016-11-20 13:14:55 |
| 5971 | 3038 | 2 | 2016-11-20 13:20:35 |
| 5972 | 3036 | 2 | 2016-11-20 13:28:45 |
| 5973 | 3039 | 2 | 2016-11-20 13:49:46 |
| 5974 | 3037 | 1 | 2016-11-20 14:39:57 |
| 5975 | 3039 | 1 | 2016-11-20 14:50:27 |
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;