Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,726–5,750 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5726 | 2699 | 2 | 2016-10-28 11:26:52 |
| 5727 | 2726 | 2 | 2016-10-28 11:26:57 |
| 5728 | 2707 | 2 | 2016-10-28 11:29:28 |
| 5729 | 2703 | 2 | 2016-10-28 11:29:38 |
| 5730 | 2711 | 2 | 2016-10-28 11:29:58 |
| 5731 | 2721 | 2 | 2016-10-28 11:30:49 |
| 5732 | 2718 | 2 | 2016-10-28 11:30:50 |
| 5733 | 2716 | 2 | 2016-10-28 11:31:07 |
| 5734 | 2700 | 2 | 2016-10-28 11:31:25 |
| 5735 | 2722 | 2 | 2016-10-28 11:31:38 |
| 5736 | 2712 | 2 | 2016-10-28 11:31:47 |
| 5737 | 2705 | 2 | 2016-10-28 11:32:30 |
| 5738 | 2710 | 2 | 2016-10-28 11:32:41 |
| 5739 | 2694 | 2 | 2016-10-28 11:33:03 |
| 5740 | 2715 | 2 | 2016-10-28 11:33:19 |
| 5741 | 2695 | 2 | 2016-10-28 11:33:45 |
| 5742 | 2724 | 2 | 2016-10-28 11:34:17 |
| 5743 | 2727 | 2 | 2016-10-28 11:34:56 |
| 5744 | 2702 | 2 | 2016-10-28 11:35:22 |
| 5745 | 2729 | 2 | 2016-10-28 11:35:26 |
| 5746 | 2728 | 2 | 2016-10-28 11:35:27 |
| 5747 | 2719 | 2 | 2016-10-28 11:35:44 |
| 5748 | 2708 | 2 | 2016-10-28 11:36:07 |
| 5749 | 2713 | 2 | 2016-10-28 11:37:12 |
| 5750 | 2698 | 2 | 2016-10-28 11:37:13 |
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;