Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,651–10,675 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10651 | 5465 | 2 | 2018-04-06 11:03:54 |
| 10652 | 5509 | 1 | 2018-04-06 11:08:37 |
| 10653 | 5509 | 2 | 2018-04-06 11:54:09 |
| 10654 | 5465 | 3 | 2018-04-06 12:01:37 |
| 10655 | 5510 | 2 | 2018-04-06 12:06:26 |
| 10656 | 5464 | 3 | 2018-04-06 12:09:54 |
| 10657 | 5472 | 3 | 2018-04-07 09:29:22 |
| 10658 | 5473 | 3 | 2018-04-07 09:30:34 |
| 10659 | 5472 | 1 | 2018-04-07 10:02:34 |
| 10660 | 5473 | 1 | 2018-04-07 10:12:00 |
| 10661 | 5524 | 2 | 2018-04-07 11:51:15 |
| 10662 | 5524 | 1 | 2018-04-07 13:06:50 |
| 10663 | 5524 | 3 | 2018-04-07 14:40:33 |
| 10664 | 5485 | 1 | 2018-04-07 15:13:21 |
| 10665 | 5484 | 2 | 2018-04-07 15:22:04 |
| 10666 | 5524 | 1 | 2018-04-07 16:09:07 |
| 10667 | 5484 | 3 | 2018-04-07 16:11:25 |
| 10668 | 5526 | 2 | 2018-04-08 10:34:27 |
| 10669 | 5525 | 1 | 2018-04-08 10:36:39 |
| 10670 | 5526 | 3 | 2018-04-08 11:31:38 |
| 10671 | 5450 | 1 | 2018-04-08 12:15:33 |
| 10672 | 5526 | 2 | 2018-04-08 12:19:30 |
| 10673 | 5450 | 3 | 2018-04-08 13:48:41 |
| 10674 | 5506 | 2 | 2018-04-09 09:10:24 |
| 10675 | 5507 | 2 | 2018-04-09 09:10:24 |
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;