Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 726–750 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 726 | 513 | 2 | 2015-05-13 16:01:59 |
| 727 | 512 | 2 | 2015-05-13 16:27:19 |
| 728 | 513 | 3 | 2015-05-13 16:44:12 |
| 729 | 511 | 3 | 2015-05-13 16:56:24 |
| 730 | 512 | 3 | 2015-05-13 17:37:24 |
| 731 | 518 | 2 | 2015-05-14 11:50:10 |
| 732 | 518 | 1 | 2015-05-14 12:52:13 |
| 733 | 524 | 1 | 2015-05-15 09:55:01 |
| 734 | 525 | 1 | 2015-05-15 09:58:42 |
| 735 | 527 | 2 | 2015-05-16 09:17:42 |
| 736 | 526 | 2 | 2015-05-16 09:19:28 |
| 737 | 528 | 2 | 2015-05-16 09:31:39 |
| 738 | 534 | 2 | 2015-05-16 09:49:04 |
| 739 | 535 | 2 | 2015-05-16 09:55:07 |
| 740 | 532 | 2 | 2015-05-16 09:56:22 |
| 741 | 536 | 2 | 2015-05-16 10:01:10 |
| 742 | 533 | 1 | 2015-05-16 10:02:10 |
| 743 | 527 | 1 | 2015-05-16 10:29:06 |
| 744 | 526 | 1 | 2015-05-16 10:51:05 |
| 745 | 528 | 1 | 2015-05-16 10:58:06 |
| 746 | 527 | 2 | 2015-05-16 11:07:14 |
| 747 | 535 | 1 | 2015-05-16 11:26:08 |
| 748 | 527 | 1 | 2015-05-16 11:33:10 |
| 749 | 528 | 2 | 2015-05-16 11:37:58 |
| 750 | 526 | 2 | 2015-05-16 11:58:58 |
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;