Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,776–2,800 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2776 | 1560 | 2 | 2015-12-06 15:05:33 |
| 2777 | 1562 | 1 | 2015-12-06 15:06:26 |
| 2778 | 1565 | 1 | 2015-12-06 15:09:02 |
| 2779 | 1563 | 1 | 2015-12-06 15:13:57 |
| 2780 | 1564 | 1 | 2015-12-06 15:21:26 |
| 2781 | 1538 | 3 | 2015-12-06 15:41:18 |
| 2782 | 1561 | 2 | 2015-12-06 15:50:04 |
| 2783 | 1564 | 3 | 2015-12-06 16:11:21 |
| 2784 | 1565 | 3 | 2015-12-06 16:15:02 |
| 2785 | 1560 | 3 | 2015-12-06 16:21:21 |
| 2786 | 1561 | 3 | 2015-12-06 16:31:35 |
| 2787 | 1562 | 3 | 2015-12-06 16:31:43 |
| 2788 | 1565 | 2 | 2015-12-06 16:55:22 |
| 2789 | 1560 | 1 | 2015-12-06 17:10:27 |
| 2790 | 1562 | 2 | 2015-12-06 17:40:16 |
| 2791 | 1564 | 2 | 2015-12-06 17:42:06 |
| 2792 | 1380 | 3 | 2015-12-07 12:18:05 |
| 2793 | 1378 | 3 | 2015-12-07 12:20:40 |
| 2794 | 1407 | 3 | 2015-12-07 12:20:53 |
| 2795 | 1388 | 3 | 2015-12-07 12:21:15 |
| 2796 | 1399 | 3 | 2015-12-07 12:21:23 |
| 2797 | 1401 | 3 | 2015-12-07 12:22:39 |
| 2798 | 1402 | 3 | 2015-12-07 12:23:24 |
| 2799 | 1377 | 3 | 2015-12-07 12:23:33 |
| 2800 | 1408 | 3 | 2015-12-07 12:23:33 |
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;