Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,701–2,725 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2701 | 1523 | 3 | 2015-11-28 17:26:09 |
| 2702 | 1527 | 2 | 2015-11-29 10:59:11 |
| 2703 | 1528 | 2 | 2015-11-29 11:05:06 |
| 2704 | 1529 | 2 | 2015-11-29 11:21:57 |
| 2705 | 1528 | 3 | 2015-11-29 12:06:47 |
| 2706 | 1529 | 3 | 2015-11-29 12:56:36 |
| 2707 | 1528 | 2 | 2015-11-29 13:33:04 |
| 2708 | 1529 | 2 | 2015-11-29 14:12:32 |
| 2709 | 1530 | 2 | 2015-11-30 13:11:10 |
| 2710 | 1531 | 2 | 2015-11-30 13:11:12 |
| 2711 | 1531 | 3 | 2015-11-30 14:12:28 |
| 2712 | 1530 | 3 | 2015-11-30 14:21:55 |
| 2713 | 1532 | 2 | 2015-11-30 15:20:28 |
| 2714 | 1543 | 2 | 2015-12-02 15:00:51 |
| 2715 | 1543 | 3 | 2015-12-02 15:50:55 |
| 2716 | 1543 | 2 | 2015-12-02 16:51:58 |
| 2717 | 1543 | 1 | 2015-12-02 17:45:12 |
| 2718 | 1441 | 1 | 2015-12-03 11:53:28 |
| 2719 | 1441 | 3 | 2015-12-03 12:40:37 |
| 2720 | 1545 | 3 | 2015-12-03 12:44:58 |
| 2721 | 1544 | 3 | 2015-12-03 12:47:51 |
| 2722 | 1544 | 2 | 2015-12-03 13:38:44 |
| 2723 | 1545 | 2 | 2015-12-03 13:38:48 |
| 2724 | 1534 | 2 | 2015-12-03 15:31:12 |
| 2725 | 1533 | 2 | 2015-12-03 15:32:23 |
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;