Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,601–4,625 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4601 | 2412 | 1 | 2016-06-27 13:28:19 |
| 4602 | 2414 | 1 | 2016-06-27 13:38:19 |
| 4603 | 2386 | 3 | 2016-06-28 13:04:58 |
| 4604 | 2386 | 1 | 2016-06-28 14:29:06 |
| 4605 | 2386 | 2 | 2016-06-28 15:35:20 |
| 4606 | 2363 | 2 | 2016-06-29 10:23:36 |
| 4607 | 2423 | 3 | 2016-06-29 13:24:33 |
| 4608 | 2390 | 2 | 2016-06-29 14:16:46 |
| 4609 | 2423 | 2 | 2016-06-29 14:31:42 |
| 4610 | 2390 | 3 | 2016-06-29 14:43:28 |
| 4611 | 2423 | 3 | 2016-06-29 15:42:38 |
| 4612 | 2429 | 1 | 2016-06-30 13:53:37 |
| 4613 | 2430 | 1 | 2016-06-30 14:00:50 |
| 4614 | 2431 | 1 | 2016-06-30 14:02:36 |
| 4615 | 2435 | 2 | 2016-07-01 12:12:42 |
| 4616 | 2433 | 2 | 2016-07-01 12:17:16 |
| 4617 | 2432 | 2 | 2016-07-01 12:21:37 |
| 4618 | 2434 | 2 | 2016-07-01 12:27:08 |
| 4619 | 2432 | 3 | 2016-07-01 12:53:12 |
| 4620 | 2397 | 3 | 2016-07-01 13:09:15 |
| 4621 | 2435 | 3 | 2016-07-01 13:20:20 |
| 4622 | 2433 | 3 | 2016-07-01 13:38:49 |
| 4623 | 2434 | 3 | 2016-07-01 13:51:46 |
| 4624 | 1900 | 2 | 2016-07-01 13:54:22 |
| 4625 | 1897 | 2 | 2016-07-01 13:55:00 |
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;