Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,726–2,750 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2726 | 1533 | 3 | 2015-12-03 16:13:54 |
| 2727 | 1533 | 1 | 2015-12-03 17:33:22 |
| 2728 | 1419 | 1 | 2015-12-04 10:10:17 |
| 2729 | 1418 | 1 | 2015-12-04 10:12:17 |
| 2730 | 1419 | 3 | 2015-12-04 11:06:58 |
| 2731 | 1549 | 2 | 2015-12-04 11:20:12 |
| 2732 | 1418 | 3 | 2015-12-04 11:39:36 |
| 2733 | 1550 | 2 | 2015-12-04 11:53:36 |
| 2734 | 1418 | 1 | 2015-12-04 12:24:33 |
| 2735 | 1549 | 3 | 2015-12-04 12:28:06 |
| 2736 | 1419 | 1 | 2015-12-04 12:34:25 |
| 2737 | 1550 | 3 | 2015-12-04 12:56:35 |
| 2738 | 1552 | 2 | 2015-12-04 14:41:40 |
| 2739 | 1551 | 2 | 2015-12-04 14:42:13 |
| 2740 | 1551 | 3 | 2015-12-04 16:08:20 |
| 2741 | 1553 | 2 | 2015-12-05 11:57:01 |
| 2742 | 1554 | 3 | 2015-12-05 11:57:27 |
| 2743 | 1554 | 1 | 2015-12-05 12:42:55 |
| 2744 | 1556 | 3 | 2015-12-06 10:05:37 |
| 2745 | 1555 | 2 | 2015-12-06 10:10:01 |
| 2746 | 1557 | 2 | 2015-12-06 10:13:17 |
| 2747 | 1558 | 2 | 2015-12-06 10:14:58 |
| 2748 | 1559 | 3 | 2015-12-06 10:37:53 |
| 2749 | 1556 | 2 | 2015-12-06 10:41:36 |
| 2750 | 1559 | 1 | 2015-12-06 11:35:54 |
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;