Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,176–4,200 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4176 | 2257 | 1 | 2016-05-14 13:48:29 |
| 4177 | 2130 | 3 | 2016-05-14 14:25:03 |
| 4178 | 2128 | 2 | 2016-05-14 14:26:42 |
| 4179 | 2129 | 2 | 2016-05-14 14:33:28 |
| 4180 | 2128 | 1 | 2016-05-14 14:55:47 |
| 4181 | 2256 | 1 | 2016-05-14 15:10:48 |
| 4182 | 2129 | 3 | 2016-05-14 15:21:23 |
| 4183 | 2130 | 2 | 2016-05-14 15:56:06 |
| 4184 | 2128 | 2 | 2016-05-14 16:18:49 |
| 4185 | 2129 | 2 | 2016-05-14 16:40:22 |
| 4186 | 2255 | 3 | 2016-05-16 11:31:50 |
| 4187 | 2267 | 2 | 2016-05-16 11:52:48 |
| 4188 | 2268 | 2 | 2016-05-16 11:54:31 |
| 4189 | 2253 | 3 | 2016-05-16 12:18:43 |
| 4190 | 2267 | 3 | 2016-05-16 12:33:58 |
| 4191 | 2255 | 1 | 2016-05-16 12:50:04 |
| 4192 | 2267 | 2 | 2016-05-16 13:23:37 |
| 4193 | 2268 | 3 | 2016-05-16 13:28:06 |
| 4194 | 2255 | 2 | 2016-05-16 13:50:13 |
| 4195 | 2268 | 1 | 2016-05-16 14:28:51 |
| 4196 | 2267 | 3 | 2016-05-16 14:40:23 |
| 4197 | 2268 | 3 | 2016-05-16 15:39:52 |
| 4198 | 2094 | 2 | 2016-05-17 13:27:55 |
| 4199 | 2095 | 2 | 2016-05-17 13:38:56 |
| 4200 | 2093 | 2 | 2016-05-17 13:39:38 |
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;