Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,751–5,775 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5751 | 2714 | 2 | 2016-10-28 11:37:17 |
| 5752 | 2706 | 2 | 2016-10-28 11:37:19 |
| 5753 | 2709 | 2 | 2016-10-28 11:37:32 |
| 5754 | 2725 | 2 | 2016-10-28 11:37:33 |
| 5755 | 2696 | 2 | 2016-10-28 11:37:47 |
| 5756 | 2730 | 2 | 2016-10-28 11:40:16 |
| 5757 | 2723 | 2 | 2016-10-28 11:42:33 |
| 5758 | 2721 | 1 | 2016-10-28 11:58:55 |
| 5759 | 2705 | 1 | 2016-10-28 12:10:20 |
| 5760 | 2718 | 1 | 2016-10-28 12:12:16 |
| 5761 | 2726 | 1 | 2016-10-28 12:12:52 |
| 5762 | 2711 | 1 | 2016-10-28 12:15:59 |
| 5763 | 2722 | 1 | 2016-10-28 12:16:00 |
| 5764 | 2723 | 1 | 2016-10-28 12:16:30 |
| 5765 | 2727 | 1 | 2016-10-28 12:18:54 |
| 5766 | 2702 | 1 | 2016-10-28 12:19:02 |
| 5767 | 2696 | 1 | 2016-10-28 12:19:11 |
| 5768 | 2724 | 1 | 2016-10-28 12:20:43 |
| 5769 | 2729 | 1 | 2016-10-28 12:21:51 |
| 5770 | 2725 | 1 | 2016-10-28 12:23:10 |
| 5771 | 2699 | 1 | 2016-10-28 12:23:40 |
| 5772 | 2698 | 1 | 2016-10-28 12:25:44 |
| 5773 | 2694 | 1 | 2016-10-28 12:27:00 |
| 5774 | 2715 | 1 | 2016-10-28 12:28:09 |
| 5775 | 2728 | 1 | 2016-10-28 12:29:32 |
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;