Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,226–4,250 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4226 | 2264 | 2 | 2016-05-20 10:45:49 |
| 4227 | 2262 | 2 | 2016-05-20 10:47:46 |
| 4228 | 2271 | 2 | 2016-05-21 12:04:22 |
| 4229 | 2272 | 3 | 2016-05-21 12:07:39 |
| 4230 | 2273 | 3 | 2016-05-21 12:11:21 |
| 4231 | 2271 | 3 | 2016-05-21 13:15:04 |
| 4232 | 2271 | 1 | 2016-05-21 13:46:00 |
| 4233 | 2258 | 2 | 2016-05-21 14:09:11 |
| 4234 | 2258 | 3 | 2016-05-21 14:38:52 |
| 4235 | 2258 | 1 | 2016-05-21 15:36:28 |
| 4236 | 2274 | 1 | 2016-05-22 13:45:44 |
| 4237 | 2276 | 1 | 2016-05-22 13:50:04 |
| 4238 | 2277 | 1 | 2016-05-22 13:55:02 |
| 4239 | 2275 | 1 | 2016-05-22 13:55:11 |
| 4240 | 2275 | 3 | 2016-05-22 14:31:14 |
| 4241 | 2277 | 3 | 2016-05-22 14:34:16 |
| 4242 | 2274 | 3 | 2016-05-22 14:42:48 |
| 4243 | 2276 | 3 | 2016-05-22 14:57:19 |
| 4244 | 2277 | 1 | 2016-05-22 15:17:58 |
| 4245 | 2274 | 1 | 2016-05-22 15:20:30 |
| 4246 | 2275 | 1 | 2016-05-22 15:34:21 |
| 4247 | 2276 | 1 | 2016-05-22 15:38:09 |
| 4248 | 2270 | 2 | 2016-05-23 09:19:31 |
| 4249 | 2269 | 2 | 2016-05-23 09:32:34 |
| 4250 | 2270 | 3 | 2016-05-23 10:17:42 |
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;