Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,701–18,725 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18701 | 9003 | 2 | 2019-12-15 12:50:21 |
| 18702 | 8974 | 1 | 2019-12-15 12:51:02 |
| 18703 | 8982 | 2 | 2019-12-15 12:53:06 |
| 18704 | 9006 | 2 | 2019-12-15 12:53:46 |
| 18705 | 8991 | 2 | 2019-12-15 12:55:12 |
| 18706 | 9008 | 1 | 2019-12-15 12:55:45 |
| 18707 | 8961 | 1 | 2019-12-15 12:55:52 |
| 18708 | 8971 | 1 | 2019-12-15 12:56:02 |
| 18709 | 8972 | 1 | 2019-12-15 12:57:15 |
| 18710 | 8987 | 2 | 2019-12-15 12:57:32 |
| 18711 | 8979 | 2 | 2019-12-15 12:59:04 |
| 18712 | 8959 | 2 | 2019-12-15 13:00:16 |
| 18713 | 8986 | 2 | 2019-12-15 13:00:23 |
| 18714 | 8975 | 2 | 2019-12-15 13:01:59 |
| 18715 | 8964 | 2 | 2019-12-15 13:06:02 |
| 18716 | 9007 | 2 | 2019-12-15 13:06:59 |
| 18717 | 8978 | 1 | 2019-12-15 13:07:51 |
| 18718 | 9000 | 1 | 2019-12-15 13:09:14 |
| 18719 | 8993 | 1 | 2019-12-15 13:10:30 |
| 18720 | 8966 | 1 | 2019-12-15 13:11:04 |
| 18721 | 8989 | 1 | 2019-12-15 13:13:54 |
| 18722 | 8968 | 1 | 2019-12-15 13:14:26 |
| 18723 | 9001 | 1 | 2019-12-15 13:15:31 |
| 18724 | 8985 | 1 | 2019-12-15 13:25:00 |
| 18725 | 8960 | 1 | 2019-12-15 13:25:10 |
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;