Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 626–650 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 626 | 426 | 3 | 2015-05-03 12:33:06 |
| 627 | 333 | 1 | 2015-05-03 12:38:40 |
| 628 | 332 | 1 | 2015-05-03 12:52:00 |
| 629 | 427 | 3 | 2015-05-03 13:01:49 |
| 630 | 425 | 3 | 2015-05-03 13:07:40 |
| 631 | 428 | 1 | 2015-05-03 14:11:44 |
| 632 | 429 | 2 | 2015-05-03 14:14:30 |
| 633 | 430 | 1 | 2015-05-03 14:16:02 |
| 634 | 431 | 1 | 2015-05-03 14:21:14 |
| 635 | 429 | 1 | 2015-05-03 15:32:07 |
| 636 | 295 | 1 | 2015-05-04 09:29:40 |
| 637 | 294 | 2 | 2015-05-04 09:40:46 |
| 638 | 295 | 3 | 2015-05-04 10:14:11 |
| 639 | 294 | 1 | 2015-05-04 10:57:40 |
| 640 | 295 | 2 | 2015-05-04 11:01:25 |
| 641 | 294 | 2 | 2015-05-04 12:14:35 |
| 642 | 437 | 1 | 2015-05-05 10:34:55 |
| 643 | 436 | 1 | 2015-05-05 10:36:56 |
| 644 | 438 | 2 | 2015-05-05 10:41:23 |
| 645 | 435 | 1 | 2015-05-05 10:42:14 |
| 646 | 439 | 1 | 2015-05-05 10:49:31 |
| 647 | 438 | 3 | 2015-05-05 12:11:58 |
| 648 | 440 | 2 | 2015-05-06 12:09:02 |
| 649 | 441 | 2 | 2015-05-06 12:16:06 |
| 650 | 441 | 3 | 2015-05-06 12:54:32 |
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;