Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,076–18,100 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18076 | 9331 | 1 | 2019-10-29 16:22:02 |
| 18077 | 9336 | 2 | 2019-10-29 17:01:56 |
| 18078 | 9335 | 2 | 2019-10-29 17:05:48 |
| 18079 | 9335 | 3 | 2019-10-29 17:40:35 |
| 18080 | 9339 | 2 | 2019-11-02 09:55:56 |
| 18081 | 9292 | 2 | 2019-11-02 10:30:28 |
| 18082 | 9339 | 3 | 2019-11-02 11:02:58 |
| 18083 | 9342 | 3 | 2019-11-02 11:33:29 |
| 18084 | 9342 | 1 | 2019-11-02 12:32:43 |
| 18085 | 9109 | 1 | 2019-11-03 11:41:20 |
| 18086 | 9111 | 2 | 2019-11-03 11:43:28 |
| 18087 | 9110 | 2 | 2019-11-03 11:49:26 |
| 18088 | 9112 | 2 | 2019-11-03 11:49:57 |
| 18089 | 9110 | 1 | 2019-11-03 12:17:58 |
| 18090 | 9112 | 1 | 2019-11-03 12:28:53 |
| 18091 | 9111 | 1 | 2019-11-03 12:32:36 |
| 18092 | 9109 | 2 | 2019-11-03 13:08:44 |
| 18093 | 9303 | 2 | 2019-11-03 14:14:46 |
| 18094 | 9303 | 3 | 2019-11-03 14:45:24 |
| 18095 | 9353 | 2 | 2019-11-04 11:48:26 |
| 18096 | 9355 | 2 | 2019-11-04 11:51:53 |
| 18097 | 9354 | 2 | 2019-11-04 11:53:21 |
| 18098 | 9356 | 2 | 2019-11-04 11:54:20 |
| 18099 | 8906 | 2 | 2019-11-05 10:09:37 |
| 18100 | 8941 | 2 | 2019-11-05 10:11:09 |
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;