Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,751–2,775 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2751 | 1539 | 2 | 2015-12-06 11:58:33 |
| 2752 | 1454 | 2 | 2015-12-06 11:59:10 |
| 2753 | 1537 | 2 | 2015-12-06 12:03:42 |
| 2754 | 1538 | 2 | 2015-12-06 12:04:00 |
| 2755 | 1455 | 2 | 2015-12-06 12:06:28 |
| 2756 | 1535 | 2 | 2015-12-06 12:07:13 |
| 2757 | 1536 | 2 | 2015-12-06 12:09:10 |
| 2758 | 1455 | 3 | 2015-12-06 12:47:06 |
| 2759 | 1536 | 1 | 2015-12-06 12:52:10 |
| 2760 | 1538 | 1 | 2015-12-06 12:59:05 |
| 2761 | 1537 | 3 | 2015-12-06 13:00:51 |
| 2762 | 1539 | 1 | 2015-12-06 13:03:35 |
| 2763 | 1455 | 1 | 2015-12-06 13:23:47 |
| 2764 | 1535 | 1 | 2015-12-06 13:25:44 |
| 2765 | 1454 | 3 | 2015-12-06 13:31:38 |
| 2766 | 1539 | 2 | 2015-12-06 13:32:02 |
| 2767 | 1536 | 2 | 2015-12-06 14:00:26 |
| 2768 | 1454 | 1 | 2015-12-06 14:10:11 |
| 2769 | 1535 | 2 | 2015-12-06 14:10:13 |
| 2770 | 1538 | 2 | 2015-12-06 14:18:45 |
| 2771 | 1560 | 3 | 2015-12-06 14:37:21 |
| 2772 | 1561 | 3 | 2015-12-06 14:49:03 |
| 2773 | 1536 | 3 | 2015-12-06 14:51:14 |
| 2774 | 1539 | 3 | 2015-12-06 15:02:01 |
| 2775 | 1535 | 3 | 2015-12-06 15:02:20 |
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;