Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,951–16,975 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16951 | 8562 | 3 | 2019-07-20 15:00:19 |
| 16952 | 8584 | 2 | 2019-07-20 15:00:37 |
| 16953 | 8583 | 2 | 2019-07-20 15:03:51 |
| 16954 | 8561 | 3 | 2019-07-20 15:12:54 |
| 16955 | 8582 | 1 | 2019-07-20 15:36:12 |
| 16956 | 8516 | 2 | 2019-07-20 16:14:18 |
| 16957 | 8584 | 3 | 2019-07-20 16:20:03 |
| 16958 | 8515 | 2 | 2019-07-20 16:24:30 |
| 16959 | 8583 | 3 | 2019-07-20 16:29:11 |
| 16960 | 8582 | 2 | 2019-07-20 16:59:10 |
| 16961 | 8515 | 3 | 2019-07-20 17:00:42 |
| 16962 | 8516 | 3 | 2019-07-20 17:04:45 |
| 16963 | 8589 | 3 | 2019-07-22 13:48:39 |
| 16964 | 8588 | 3 | 2019-07-22 13:59:11 |
| 16965 | 8595 | 2 | 2019-07-23 11:02:48 |
| 16966 | 8596 | 2 | 2019-07-23 11:15:59 |
| 16967 | 8595 | 1 | 2019-07-23 12:28:38 |
| 16968 | 8596 | 1 | 2019-07-23 12:47:24 |
| 16969 | 8551 | 2 | 2019-07-24 10:47:08 |
| 16970 | 8550 | 2 | 2019-07-24 10:50:07 |
| 16971 | 8550 | 3 | 2019-07-24 11:16:57 |
| 16972 | 8585 | 3 | 2019-07-24 12:04:56 |
| 16973 | 8551 | 3 | 2019-07-24 12:17:07 |
| 16974 | 8550 | 2 | 2019-07-24 12:18:22 |
| 16975 | 8631 | 1 | 2019-07-24 12:21:24 |
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;