Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,351–4,375 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4351 | 2318 | 2 | 2016-06-02 09:38:24 |
| 4352 | 2319 | 2 | 2016-06-02 11:13:35 |
| 4353 | 2319 | 3 | 2016-06-02 12:14:11 |
| 4354 | 2319 | 2 | 2016-06-02 13:31:35 |
| 4355 | 2265 | 2 | 2016-06-03 09:42:13 |
| 4356 | 2266 | 2 | 2016-06-03 09:51:15 |
| 4357 | 2265 | 3 | 2016-06-03 10:59:36 |
| 4358 | 2266 | 3 | 2016-06-03 11:06:30 |
| 4359 | 2327 | 3 | 2016-06-03 11:16:50 |
| 4360 | 2265 | 1 | 2016-06-03 11:28:47 |
| 4361 | 2266 | 1 | 2016-06-03 12:06:13 |
| 4362 | 2265 | 2 | 2016-06-03 12:46:28 |
| 4363 | 2266 | 2 | 2016-06-03 13:01:03 |
| 4364 | 2282 | 2 | 2016-06-04 10:30:00 |
| 4365 | 2290 | 1 | 2016-06-04 11:27:14 |
| 4366 | 2291 | 1 | 2016-06-04 11:28:18 |
| 4367 | 2282 | 3 | 2016-06-04 11:49:48 |
| 4368 | 2308 | 2 | 2016-06-04 12:53:09 |
| 4369 | 2335 | 3 | 2016-06-04 12:54:24 |
| 4370 | 2307 | 2 | 2016-06-04 12:55:10 |
| 4371 | 2334 | 3 | 2016-06-04 12:56:35 |
| 4372 | 2334 | 1 | 2016-06-04 13:32:24 |
| 4373 | 2335 | 1 | 2016-06-04 14:09:56 |
| 4374 | 2335 | 2 | 2016-06-04 14:45:37 |
| 4375 | 2334 | 2 | 2016-06-04 14:54:14 |
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;