Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,451–12,475 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12451 | 6456 | 3 | 2018-08-17 12:30:21 |
| 12452 | 6459 | 3 | 2018-08-17 12:43:01 |
| 12453 | 6480 | 1 | 2018-08-17 12:43:55 |
| 12454 | 6479 | 1 | 2018-08-17 12:51:54 |
| 12455 | 6458 | 2 | 2018-08-17 12:53:20 |
| 12456 | 6482 | 1 | 2018-08-17 12:57:29 |
| 12457 | 6455 | 3 | 2018-08-17 13:24:07 |
| 12458 | 6192 | 2 | 2018-08-18 10:48:30 |
| 12459 | 6487 | 2 | 2018-08-18 10:49:26 |
| 12460 | 6488 | 2 | 2018-08-18 10:54:18 |
| 12461 | 6486 | 1 | 2018-08-18 10:54:54 |
| 12462 | 6485 | 2 | 2018-08-18 10:56:51 |
| 12463 | 6192 | 3 | 2018-08-18 11:33:44 |
| 12464 | 6192 | 2 | 2018-08-18 12:14:18 |
| 12465 | 6489 | 2 | 2018-08-18 12:54:59 |
| 12466 | 6441 | 3 | 2018-08-18 12:56:14 |
| 12467 | 6490 | 2 | 2018-08-18 13:01:18 |
| 12468 | 6491 | 2 | 2018-08-18 13:06:14 |
| 12469 | 6441 | 2 | 2018-08-18 14:09:00 |
| 12470 | 6245 | 1 | 2018-08-18 15:13:57 |
| 12471 | 6247 | 1 | 2018-08-18 15:14:08 |
| 12472 | 6244 | 1 | 2018-08-18 15:14:30 |
| 12473 | 6246 | 1 | 2018-08-18 15:17:42 |
| 12474 | 6492 | 2 | 2018-08-18 16:08:04 |
| 12475 | 6493 | 2 | 2018-08-18 16:09:31 |
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;