Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,676–2,700 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2676 | 1516 | 1 | 2015-11-26 14:34:30 |
| 2677 | 1514 | 3 | 2015-11-26 14:39:38 |
| 2678 | 1514 | 2 | 2015-11-26 15:20:58 |
| 2679 | 1519 | 3 | 2015-11-27 10:11:43 |
| 2680 | 1518 | 3 | 2015-11-27 10:12:26 |
| 2681 | 1517 | 3 | 2015-11-27 10:16:46 |
| 2682 | 1520 | 3 | 2015-11-27 10:19:19 |
| 2683 | 1517 | 2 | 2015-11-27 10:42:30 |
| 2684 | 1437 | 1 | 2015-11-27 11:20:00 |
| 2685 | 1440 | 1 | 2015-11-27 11:20:30 |
| 2686 | 1439 | 1 | 2015-11-27 11:23:18 |
| 2687 | 1438 | 2 | 2015-11-27 11:28:37 |
| 2688 | 1517 | 1 | 2015-11-27 11:31:58 |
| 2689 | 1439 | 2 | 2015-11-27 12:07:09 |
| 2690 | 1440 | 2 | 2015-11-27 12:07:26 |
| 2691 | 1437 | 2 | 2015-11-27 12:15:06 |
| 2692 | 1438 | 3 | 2015-11-27 12:15:52 |
| 2693 | 1438 | 2 | 2015-11-27 13:01:45 |
| 2694 | 1521 | 2 | 2015-11-27 15:21:48 |
| 2695 | 1522 | 2 | 2015-11-27 15:29:13 |
| 2696 | 1521 | 1 | 2015-11-27 15:59:26 |
| 2697 | 1522 | 1 | 2015-11-27 16:59:43 |
| 2698 | 1521 | 2 | 2015-11-27 17:16:44 |
| 2699 | 1523 | 2 | 2015-11-28 15:57:45 |
| 2700 | 1524 | 2 | 2015-11-28 15:59:01 |
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;