Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 426–450 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 426 | 38 | 2 | 2015-04-25 12:02:32 |
| 427 | 18 | 2 | 2015-04-25 12:02:42 |
| 428 | 59 | 2 | 2015-04-25 12:03:43 |
| 429 | 39 | 2 | 2015-04-25 12:04:10 |
| 430 | 44 | 2 | 2015-04-25 12:04:10 |
| 431 | 299 | 2 | 2015-04-25 12:04:20 |
| 432 | 57 | 2 | 2015-04-25 12:05:17 |
| 433 | 41 | 2 | 2015-04-25 12:06:11 |
| 434 | 29 | 2 | 2015-04-25 12:06:31 |
| 435 | 21 | 2 | 2015-04-25 12:07:46 |
| 436 | 25 | 2 | 2015-04-25 12:09:44 |
| 437 | 37 | 2 | 2015-04-25 12:10:33 |
| 438 | 47 | 2 | 2015-04-25 12:11:04 |
| 439 | 15 | 1 | 2015-04-25 12:12:33 |
| 440 | 56 | 1 | 2015-04-25 12:13:19 |
| 441 | 20 | 2 | 2015-04-25 12:13:47 |
| 442 | 45 | 2 | 2015-04-25 12:16:23 |
| 443 | 42 | 1 | 2015-04-25 12:16:28 |
| 444 | 34 | 2 | 2015-04-25 12:18:06 |
| 445 | 19 | 1 | 2015-04-25 12:18:23 |
| 446 | 60 | 2 | 2015-04-25 12:18:59 |
| 447 | 58 | 1 | 2015-04-25 12:19:50 |
| 448 | 31 | 2 | 2015-04-25 12:20:04 |
| 449 | 63 | 2 | 2015-04-25 12:20:22 |
| 450 | 10 | 2 | 2015-04-25 12:21:35 |
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;