Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,276–18,300 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18276 | 9387 | 1 | 2019-11-11 10:46:31 |
| 18277 | 9385 | 2 | 2019-11-11 10:48:56 |
| 18278 | 9384 | 3 | 2019-11-11 10:52:44 |
| 18279 | 9386 | 1 | 2019-11-11 10:53:12 |
| 18280 | 9388 | 3 | 2019-11-11 11:15:41 |
| 18281 | 9390 | 3 | 2019-11-11 11:22:01 |
| 18282 | 9387 | 2 | 2019-11-11 11:22:39 |
| 18283 | 9384 | 2 | 2019-11-11 12:07:10 |
| 18284 | 9386 | 2 | 2019-11-11 12:23:36 |
| 18285 | 9384 | 3 | 2019-11-11 12:50:08 |
| 18286 | 9384 | 2 | 2019-11-11 14:19:06 |
| 18287 | 9396 | 1 | 2019-11-12 10:55:38 |
| 18288 | 9396 | 2 | 2019-11-12 11:51:23 |
| 18289 | 9396 | 3 | 2019-11-12 13:24:50 |
| 18290 | 9393 | 1 | 2019-11-13 10:13:42 |
| 18291 | 9394 | 1 | 2019-11-13 10:21:38 |
| 18292 | 9393 | 3 | 2019-11-13 11:36:20 |
| 18293 | 9394 | 3 | 2019-11-13 11:36:55 |
| 18294 | 9401 | 2 | 2019-11-13 11:56:54 |
| 18295 | 9402 | 2 | 2019-11-13 12:08:59 |
| 18296 | 9402 | 3 | 2019-11-13 12:49:46 |
| 18297 | 9401 | 1 | 2019-11-13 13:21:43 |
| 18298 | 9402 | 2 | 2019-11-13 14:18:58 |
| 18299 | 9306 | 1 | 2019-11-13 15:00:55 |
| 18300 | 9402 | 1 | 2019-11-13 15:46:30 |
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;