Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,701–15,725 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15701 | 8086 | 2 | 2019-04-17 11:17:53 |
| 15702 | 8086 | 3 | 2019-04-17 11:56:47 |
| 15703 | 7900 | 3 | 2019-04-17 13:02:35 |
| 15704 | 7901 | 2 | 2019-04-17 13:06:50 |
| 15705 | 8086 | 2 | 2019-04-17 13:07:46 |
| 15706 | 8086 | 3 | 2019-04-17 14:06:12 |
| 15707 | 8087 | 2 | 2019-04-17 15:35:57 |
| 15708 | 8087 | 1 | 2019-04-17 16:22:40 |
| 15709 | 8085 | 2 | 2019-04-19 10:11:22 |
| 15710 | 8085 | 3 | 2019-04-19 11:28:36 |
| 15711 | 8095 | 2 | 2019-04-19 11:59:54 |
| 15712 | 8096 | 2 | 2019-04-19 12:07:33 |
| 15713 | 8085 | 1 | 2019-04-19 12:59:39 |
| 15714 | 8095 | 1 | 2019-04-19 13:12:21 |
| 15715 | 7678 | 1 | 2019-04-19 13:18:42 |
| 15716 | 7687 | 1 | 2019-04-19 13:20:20 |
| 15717 | 7674 | 1 | 2019-04-19 13:20:59 |
| 15718 | 7660 | 1 | 2019-04-19 13:21:01 |
| 15719 | 7691 | 1 | 2019-04-19 13:21:44 |
| 15720 | 7698 | 1 | 2019-04-19 13:22:12 |
| 15721 | 7701 | 1 | 2019-04-19 13:22:42 |
| 15722 | 7665 | 1 | 2019-04-19 13:22:55 |
| 15723 | 7685 | 1 | 2019-04-19 13:23:47 |
| 15724 | 7671 | 1 | 2019-04-19 13:24:24 |
| 15725 | 7673 | 1 | 2019-04-19 13:24:51 |
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;