Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,651–11,675 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11651 | 6179 | 1 | 2018-07-05 11:20:31 |
| 11652 | 6178 | 1 | 2018-07-05 11:33:17 |
| 11653 | 6177 | 1 | 2018-07-05 11:33:29 |
| 11654 | 6177 | 3 | 2018-07-05 11:59:08 |
| 11655 | 6181 | 1 | 2018-07-05 12:08:47 |
| 11656 | 6180 | 1 | 2018-07-05 12:10:48 |
| 11657 | 6179 | 3 | 2018-07-05 12:28:43 |
| 11658 | 6068 | 2 | 2018-07-05 12:34:26 |
| 11659 | 6069 | 2 | 2018-07-05 12:42:57 |
| 11660 | 6178 | 3 | 2018-07-05 13:00:12 |
| 11661 | 6182 | 3 | 2018-07-05 13:15:39 |
| 11662 | 6177 | 2 | 2018-07-05 13:18:50 |
| 11663 | 6179 | 2 | 2018-07-05 13:37:44 |
| 11664 | 6068 | 1 | 2018-07-05 13:46:18 |
| 11665 | 6177 | 3 | 2018-07-05 14:14:14 |
| 11666 | 6069 | 1 | 2018-07-05 14:15:32 |
| 11667 | 6178 | 2 | 2018-07-05 14:23:22 |
| 11668 | 6068 | 3 | 2018-07-05 14:25:37 |
| 11669 | 6182 | 1 | 2018-07-05 14:28:35 |
| 11670 | 6178 | 3 | 2018-07-05 15:04:25 |
| 11671 | 6179 | 3 | 2018-07-05 15:05:06 |
| 11672 | 6182 | 2 | 2018-07-05 15:06:49 |
| 11673 | 6177 | 1 | 2018-07-05 15:34:46 |
| 11674 | 6178 | 1 | 2018-07-05 16:07:45 |
| 11675 | 6179 | 1 | 2018-07-05 16:27:42 |
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;