Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,701–17,725 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17701 | 9101 | 3 | 2019-09-22 13:15:34 |
| 17702 | 9102 | 3 | 2019-09-22 13:16:31 |
| 17703 | 9096 | 2 | 2019-09-22 13:25:24 |
| 17704 | 9096 | 3 | 2019-09-22 14:01:29 |
| 17705 | 9085 | 1 | 2019-09-22 15:39:08 |
| 17706 | 9086 | 2 | 2019-09-22 15:48:45 |
| 17707 | 9085 | 2 | 2019-09-22 16:15:37 |
| 17708 | 9086 | 1 | 2019-09-22 16:43:58 |
| 17709 | 9107 | 2 | 2019-09-23 10:39:55 |
| 17710 | 9090 | 2 | 2019-09-23 10:52:37 |
| 17711 | 9108 | 1 | 2019-09-23 10:52:39 |
| 17712 | 9092 | 2 | 2019-09-23 10:55:49 |
| 17713 | 9091 | 2 | 2019-09-23 10:59:10 |
| 17714 | 9093 | 2 | 2019-09-23 11:03:00 |
| 17715 | 9108 | 3 | 2019-09-23 11:37:20 |
| 17716 | 9107 | 1 | 2019-09-23 12:12:16 |
| 17717 | 9093 | 3 | 2019-09-23 12:13:29 |
| 17718 | 9090 | 3 | 2019-09-23 12:14:23 |
| 17719 | 9091 | 3 | 2019-09-23 12:17:14 |
| 17720 | 9092 | 3 | 2019-09-23 12:17:49 |
| 17721 | 9089 | 1 | 2019-09-24 11:38:17 |
| 17722 | 8870 | 2 | 2019-09-24 11:39:42 |
| 17723 | 9115 | 1 | 2019-09-26 13:04:00 |
| 17724 | 9115 | 2 | 2019-09-26 13:52:26 |
| 17725 | 9115 | 1 | 2019-09-26 15:27:19 |
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;