Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,751–16,775 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16751 | 8541 | 3 | 2019-07-13 14:24:30 |
| 16752 | 8539 | 2 | 2019-07-13 14:57:33 |
| 16753 | 8429 | 3 | 2019-07-13 15:00:32 |
| 16754 | 8541 | 2 | 2019-07-13 15:03:04 |
| 16755 | 8540 | 2 | 2019-07-13 15:36:17 |
| 16756 | 8429 | 1 | 2019-07-13 16:26:22 |
| 16757 | 8514 | 2 | 2019-07-14 09:16:58 |
| 16758 | 8513 | 2 | 2019-07-14 09:17:42 |
| 16759 | 8554 | 1 | 2019-07-14 10:33:20 |
| 16760 | 8555 | 1 | 2019-07-14 10:43:30 |
| 16761 | 8554 | 2 | 2019-07-14 11:00:20 |
| 16762 | 8546 | 3 | 2019-07-14 11:04:30 |
| 16763 | 8547 | 2 | 2019-07-14 11:07:58 |
| 16764 | 8548 | 3 | 2019-07-14 11:09:13 |
| 16765 | 7932 | 2 | 2019-07-14 11:09:21 |
| 16766 | 7938 | 2 | 2019-07-14 11:09:54 |
| 16767 | 7934 | 2 | 2019-07-14 11:11:01 |
| 16768 | 7942 | 2 | 2019-07-14 11:11:29 |
| 16769 | 7939 | 2 | 2019-07-14 11:12:16 |
| 16770 | 7943 | 2 | 2019-07-14 11:12:16 |
| 16771 | 7944 | 2 | 2019-07-14 11:12:43 |
| 16772 | 8517 | 1 | 2019-07-14 11:13:21 |
| 16773 | 7940 | 2 | 2019-07-14 11:14:40 |
| 16774 | 7954 | 2 | 2019-07-14 11:15:15 |
| 16775 | 7959 | 2 | 2019-07-14 11:15:35 |
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;