Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,951–12,975 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12951 | 6576 | 3 | 2018-08-31 13:40:54 |
| 12952 | 6577 | 3 | 2018-08-31 13:42:37 |
| 12953 | 6577 | 1 | 2018-08-31 14:10:43 |
| 12954 | 6576 | 1 | 2018-08-31 14:14:19 |
| 12955 | 6579 | 1 | 2018-08-31 14:22:04 |
| 12956 | 6564 | 1 | 2018-08-31 14:28:07 |
| 12957 | 6565 | 1 | 2018-08-31 14:33:12 |
| 12958 | 6598 | 2 | 2018-08-31 15:09:30 |
| 12959 | 6600 | 2 | 2018-08-31 15:14:23 |
| 12960 | 6599 | 2 | 2018-08-31 15:16:18 |
| 12961 | 6601 | 2 | 2018-08-31 15:20:43 |
| 12962 | 6564 | 3 | 2018-08-31 15:32:02 |
| 12963 | 6565 | 3 | 2018-08-31 15:53:30 |
| 12964 | 6564 | 1 | 2018-08-31 16:25:35 |
| 12965 | 6600 | 1 | 2018-08-31 16:28:10 |
| 12966 | 6598 | 1 | 2018-08-31 16:34:52 |
| 12967 | 6599 | 1 | 2018-08-31 16:36:56 |
| 12968 | 6601 | 1 | 2018-08-31 16:54:43 |
| 12969 | 6600 | 2 | 2018-08-31 16:55:22 |
| 12970 | 6565 | 1 | 2018-08-31 17:16:43 |
| 12971 | 6598 | 2 | 2018-08-31 17:30:11 |
| 12972 | 6599 | 2 | 2018-08-31 17:38:30 |
| 12973 | 6442 | 3 | 2018-09-01 16:38:33 |
| 12974 | 6442 | 1 | 2018-09-01 17:11:58 |
| 12975 | 6602 | 2 | 2018-09-02 10:15:22 |
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;