Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,051–13,075 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13051 | 6693 | 2 | 2018-09-12 10:28:38 |
| 13052 | 6694 | 2 | 2018-09-12 11:39:08 |
| 13053 | 6695 | 2 | 2018-09-12 11:42:17 |
| 13054 | 6694 | 3 | 2018-09-12 12:55:31 |
| 13055 | 6695 | 3 | 2018-09-12 12:59:54 |
| 13056 | 6574 | 3 | 2018-09-14 10:19:44 |
| 13057 | 6575 | 3 | 2018-09-14 10:22:53 |
| 13058 | 6706 | 1 | 2018-09-14 11:09:45 |
| 13059 | 6705 | 1 | 2018-09-14 11:10:05 |
| 13060 | 6704 | 2 | 2018-09-14 11:11:11 |
| 13061 | 6707 | 1 | 2018-09-14 11:16:42 |
| 13062 | 6707 | 3 | 2018-09-14 12:08:15 |
| 13063 | 6705 | 3 | 2018-09-14 12:26:13 |
| 13064 | 6706 | 3 | 2018-09-14 12:32:11 |
| 13065 | 6710 | 2 | 2018-09-15 09:56:51 |
| 13066 | 6712 | 2 | 2018-09-15 11:09:22 |
| 13067 | 6711 | 2 | 2018-09-15 11:13:38 |
| 13068 | 6710 | 1 | 2018-09-15 11:30:58 |
| 13069 | 6712 | 3 | 2018-09-15 11:42:31 |
| 13070 | 6711 | 3 | 2018-09-15 11:43:11 |
| 13071 | 6710 | 3 | 2018-09-15 12:23:03 |
| 13072 | 6714 | 2 | 2018-09-16 12:10:19 |
| 13073 | 6715 | 2 | 2018-09-16 12:15:14 |
| 13074 | 6713 | 3 | 2018-09-16 12:21:37 |
| 13075 | 6715 | 1 | 2018-09-16 13:07:15 |
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;