Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,626–11,650 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11626 | 6116 | 1 | 2018-06-30 14:26:19 |
| 11627 | 6087 | 2 | 2018-06-30 17:02:05 |
| 11628 | 6085 | 2 | 2018-06-30 17:05:10 |
| 11629 | 6084 | 2 | 2018-06-30 17:09:40 |
| 11630 | 6086 | 2 | 2018-06-30 17:12:27 |
| 11631 | 6083 | 2 | 2018-06-30 17:12:48 |
| 11632 | 6082 | 2 | 2018-07-01 10:35:35 |
| 11633 | 6166 | 2 | 2018-07-01 11:04:34 |
| 11634 | 6167 | 2 | 2018-07-01 11:09:23 |
| 11635 | 6166 | 1 | 2018-07-01 11:33:43 |
| 11636 | 6073 | 2 | 2018-07-01 12:25:09 |
| 11637 | 6074 | 2 | 2018-07-01 12:34:16 |
| 11638 | 6167 | 1 | 2018-07-01 12:40:26 |
| 11639 | 6074 | 1 | 2018-07-01 13:19:45 |
| 11640 | 6073 | 1 | 2018-07-01 13:27:54 |
| 11641 | 6099 | 2 | 2018-07-02 13:38:27 |
| 11642 | 6170 | 1 | 2018-07-02 16:53:20 |
| 11643 | 6172 | 2 | 2018-07-03 14:45:43 |
| 11644 | 6173 | 2 | 2018-07-03 14:54:05 |
| 11645 | 6173 | 3 | 2018-07-03 15:46:03 |
| 11646 | 6172 | 3 | 2018-07-03 15:59:22 |
| 11647 | 6112 | 2 | 2018-07-04 15:45:24 |
| 11648 | 6113 | 2 | 2018-07-04 15:55:34 |
| 11649 | 6112 | 1 | 2018-07-04 17:07:33 |
| 11650 | 6111 | 3 | 2018-07-05 10:40:19 |
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;