Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,501–14,525 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14501 | 7452 | 2 | 2019-01-24 14:59:51 |
| 14502 | 7470 | 2 | 2019-01-24 15:09:35 |
| 14503 | 7471 | 2 | 2019-01-24 15:17:14 |
| 14504 | 7452 | 3 | 2019-01-24 16:01:02 |
| 14505 | 7471 | 1 | 2019-01-24 16:28:21 |
| 14506 | 7471 | 2 | 2019-01-24 17:43:15 |
| 14507 | 7466 | 2 | 2019-01-25 16:59:57 |
| 14508 | 7467 | 2 | 2019-01-25 17:10:32 |
| 14509 | 7466 | 1 | 2019-01-25 17:45:04 |
| 14510 | 7472 | 2 | 2019-01-27 12:27:04 |
| 14511 | 7472 | 1 | 2019-01-27 13:55:07 |
| 14512 | 7472 | 2 | 2019-01-27 14:32:57 |
| 14513 | 7472 | 1 | 2019-01-27 15:50:54 |
| 14514 | 7446 | 3 | 2019-01-28 11:04:15 |
| 14515 | 7447 | 2 | 2019-01-28 11:06:59 |
| 14516 | 7446 | 2 | 2019-01-28 12:13:41 |
| 14517 | 7473 | 2 | 2019-01-29 10:15:51 |
| 14518 | 7450 | 2 | 2019-01-30 09:19:36 |
| 14519 | 7449 | 2 | 2019-01-30 09:28:28 |
| 14520 | 7526 | 2 | 2019-01-30 12:10:48 |
| 14521 | 7526 | 3 | 2019-01-30 13:10:37 |
| 14522 | 7526 | 2 | 2019-01-30 14:33:09 |
| 14523 | 7577 | 2 | 2019-02-01 11:20:24 |
| 14524 | 7576 | 2 | 2019-02-01 11:31:24 |
| 14525 | 7576 | 3 | 2019-02-01 11:57:43 |
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;