Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,051–16,075 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16051 | 8238 | 2 | 2019-05-18 14:47:34 |
| 16052 | 8250 | 2 | 2019-05-19 11:07:38 |
| 16053 | 8249 | 2 | 2019-05-19 11:11:53 |
| 16054 | 8248 | 1 | 2019-05-19 11:54:15 |
| 16055 | 8245 | 1 | 2019-05-19 11:54:48 |
| 16056 | 8247 | 1 | 2019-05-19 11:59:16 |
| 16057 | 8246 | 1 | 2019-05-19 12:03:33 |
| 16058 | 8249 | 1 | 2019-05-19 12:06:06 |
| 16059 | 8246 | 3 | 2019-05-19 12:30:22 |
| 16060 | 8248 | 3 | 2019-05-19 12:39:45 |
| 16061 | 8252 | 1 | 2019-05-19 13:01:08 |
| 16062 | 8251 | 3 | 2019-05-19 13:03:17 |
| 16063 | 8246 | 2 | 2019-05-19 13:06:25 |
| 16064 | 8245 | 3 | 2019-05-19 13:21:12 |
| 16065 | 8249 | 3 | 2019-05-19 13:22:43 |
| 16066 | 8252 | 2 | 2019-05-19 13:40:53 |
| 16067 | 8248 | 2 | 2019-05-19 13:48:04 |
| 16068 | 8249 | 2 | 2019-05-19 14:02:08 |
| 16069 | 8245 | 2 | 2019-05-19 14:23:31 |
| 16070 | 8252 | 1 | 2019-05-19 14:43:02 |
| 16071 | 8253 | 2 | 2019-05-20 10:42:46 |
| 16072 | 8229 | 2 | 2019-05-21 11:28:02 |
| 16073 | 8228 | 2 | 2019-05-21 11:34:21 |
| 16074 | 8230 | 2 | 2019-05-21 11:41:53 |
| 16075 | 8244 | 2 | 2019-05-21 11:49:04 |
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;