Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,776–5,800 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5776 | 2709 | 1 | 2016-10-28 12:30:03 |
| 5777 | 2695 | 1 | 2016-10-28 12:31:20 |
| 5778 | 2697 | 1 | 2016-10-28 12:33:50 |
| 5779 | 2730 | 1 | 2016-10-28 12:34:07 |
| 5780 | 2703 | 1 | 2016-10-28 12:39:00 |
| 5781 | 2706 | 1 | 2016-10-28 12:41:27 |
| 5782 | 2710 | 1 | 2016-10-28 12:42:26 |
| 5783 | 2713 | 1 | 2016-10-28 12:42:26 |
| 5784 | 2704 | 1 | 2016-10-28 12:43:29 |
| 5785 | 2721 | 2 | 2016-10-28 12:49:33 |
| 5786 | 2696 | 2 | 2016-10-28 12:50:25 |
| 5787 | 2712 | 1 | 2016-10-28 12:51:28 |
| 5788 | 2705 | 2 | 2016-10-28 12:52:11 |
| 5789 | 2716 | 1 | 2016-10-28 12:53:46 |
| 5790 | 2718 | 2 | 2016-10-28 12:56:27 |
| 5791 | 2700 | 1 | 2016-10-28 12:58:18 |
| 5792 | 2728 | 2 | 2016-10-28 12:58:29 |
| 5793 | 2707 | 1 | 2016-10-28 12:58:35 |
| 5794 | 2724 | 2 | 2016-10-28 13:01:16 |
| 5795 | 2714 | 1 | 2016-10-28 13:02:58 |
| 5796 | 2729 | 2 | 2016-10-28 13:03:41 |
| 5797 | 2708 | 1 | 2016-10-28 13:03:42 |
| 5798 | 2725 | 2 | 2016-10-28 13:06:02 |
| 5799 | 2719 | 1 | 2016-10-28 13:10:39 |
| 5800 | 2697 | 2 | 2016-10-28 13:12:16 |
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;