Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,376–6,400 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6376 | 3395 | 3 | 2017-01-12 15:36:24 |
| 6377 | 3396 | 2 | 2017-01-12 16:26:10 |
| 6378 | 3397 | 3 | 2017-01-12 16:33:48 |
| 6379 | 3395 | 2 | 2017-01-12 16:53:58 |
| 6380 | 3397 | 2 | 2017-01-12 17:15:19 |
| 6381 | 3402 | 3 | 2017-01-14 12:25:43 |
| 6382 | 3401 | 3 | 2017-01-14 12:37:38 |
| 6383 | 3402 | 2 | 2017-01-14 13:36:43 |
| 6384 | 3401 | 2 | 2017-01-14 14:04:34 |
| 6385 | 3403 | 2 | 2017-01-14 16:05:03 |
| 6386 | 3403 | 1 | 2017-01-14 16:52:54 |
| 6387 | 3407 | 1 | 2017-01-16 11:14:00 |
| 6388 | 3406 | 3 | 2017-01-16 11:14:14 |
| 6389 | 3393 | 3 | 2017-01-17 14:05:25 |
| 6390 | 3410 | 2 | 2017-01-17 14:39:30 |
| 6391 | 3411 | 2 | 2017-01-17 14:40:56 |
| 6392 | 3393 | 1 | 2017-01-17 15:27:55 |
| 6393 | 3411 | 1 | 2017-01-17 15:40:36 |
| 6394 | 3393 | 3 | 2017-01-17 16:10:52 |
| 6395 | 3410 | 1 | 2017-01-17 16:11:01 |
| 6396 | 3411 | 3 | 2017-01-17 16:45:49 |
| 6397 | 3410 | 3 | 2017-01-17 17:44:08 |
| 6398 | 3409 | 2 | 2017-01-18 12:52:01 |
| 6399 | 3408 | 2 | 2017-01-18 12:59:27 |
| 6400 | 3394 | 2 | 2017-01-19 11:18:41 |
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;