Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,801–5,825 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5801 | 2698 | 2 | 2016-10-28 13:12:58 |
| 5802 | 2727 | 2 | 2016-10-28 13:14:08 |
| 5803 | 2713 | 2 | 2016-10-28 13:17:23 |
| 5804 | 2709 | 2 | 2016-10-28 13:18:13 |
| 5805 | 2715 | 2 | 2016-10-28 13:20:25 |
| 5806 | 2722 | 2 | 2016-10-28 13:27:47 |
| 5807 | 2695 | 2 | 2016-10-28 13:27:59 |
| 5808 | 2704 | 2 | 2016-10-28 13:30:41 |
| 5809 | 2726 | 2 | 2016-10-28 13:36:21 |
| 5810 | 2719 | 2 | 2016-10-28 13:39:15 |
| 5811 | 2711 | 2 | 2016-10-28 13:41:31 |
| 5812 | 2730 | 2 | 2016-10-28 13:43:21 |
| 5813 | 2712 | 2 | 2016-10-28 13:43:33 |
| 5814 | 2706 | 2 | 2016-10-28 13:50:57 |
| 5815 | 2723 | 2 | 2016-10-28 13:51:18 |
| 5816 | 2702 | 2 | 2016-10-28 13:52:18 |
| 5817 | 2714 | 2 | 2016-10-28 13:54:18 |
| 5818 | 2699 | 2 | 2016-10-28 13:55:09 |
| 5819 | 2694 | 2 | 2016-10-28 13:56:11 |
| 5820 | 2703 | 2 | 2016-10-28 13:56:35 |
| 5821 | 2716 | 2 | 2016-10-28 14:08:32 |
| 5822 | 2710 | 2 | 2016-10-28 14:09:37 |
| 5823 | 2700 | 2 | 2016-10-28 14:21:28 |
| 5824 | 2708 | 2 | 2016-10-28 14:31:05 |
| 5825 | 2707 | 2 | 2016-10-28 14:32:01 |
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;