Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,301–8,325 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8301 | 4304 | 3 | 2017-07-25 10:34:42 |
| 8302 | 4304 | 1 | 2017-07-25 11:03:16 |
| 8303 | 4304 | 3 | 2017-07-25 11:30:54 |
| 8304 | 4303 | 1 | 2017-07-25 11:37:21 |
| 8305 | 4271 | 2 | 2017-07-25 11:48:58 |
| 8306 | 4270 | 2 | 2017-07-25 11:54:22 |
| 8307 | 4269 | 2 | 2017-07-25 12:07:47 |
| 8308 | 4268 | 2 | 2017-07-25 12:12:46 |
| 8309 | 4269 | 3 | 2017-07-25 12:42:07 |
| 8310 | 4270 | 1 | 2017-07-25 12:47:19 |
| 8311 | 4268 | 3 | 2017-07-25 12:52:38 |
| 8312 | 4303 | 3 | 2017-07-25 12:55:43 |
| 8313 | 4271 | 1 | 2017-07-25 13:07:19 |
| 8314 | 4270 | 2 | 2017-07-25 13:16:41 |
| 8315 | 4268 | 2 | 2017-07-25 14:11:22 |
| 8316 | 4269 | 2 | 2017-07-25 14:15:10 |
| 8317 | 4271 | 2 | 2017-07-25 14:25:44 |
| 8318 | 4278 | 2 | 2017-07-27 11:39:41 |
| 8319 | 4279 | 2 | 2017-07-27 11:44:16 |
| 8320 | 4278 | 3 | 2017-07-27 12:16:22 |
| 8321 | 4279 | 3 | 2017-07-27 12:21:31 |
| 8322 | 4295 | 2 | 2017-07-27 16:49:43 |
| 8323 | 4307 | 3 | 2017-07-28 10:29:38 |
| 8324 | 4306 | 1 | 2017-07-28 10:32:21 |
| 8325 | 4306 | 3 | 2017-07-28 11:18:43 |
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;