Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 751–775 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 751 | 528 | 1 | 2015-05-16 12:15:39 |
| 752 | 535 | 3 | 2015-05-16 12:44:57 |
| 753 | 526 | 1 | 2015-05-16 13:21:58 |
| 754 | 535 | 2 | 2015-05-16 13:57:35 |
| 755 | 535 | 1 | 2015-05-16 14:45:57 |
| 756 | 537 | 1 | 2015-05-16 15:35:03 |
| 757 | 521 | 2 | 2015-05-17 11:38:47 |
| 758 | 520 | 2 | 2015-05-17 11:40:37 |
| 759 | 522 | 2 | 2015-05-17 11:47:59 |
| 760 | 519 | 2 | 2015-05-17 11:50:15 |
| 761 | 522 | 3 | 2015-05-17 12:23:09 |
| 762 | 521 | 1 | 2015-05-17 12:26:56 |
| 763 | 521 | 3 | 2015-05-17 13:17:25 |
| 764 | 538 | 2 | 2015-05-17 14:22:58 |
| 765 | 539 | 2 | 2015-05-17 14:24:08 |
| 766 | 542 | 1 | 2015-05-18 10:33:20 |
| 767 | 541 | 2 | 2015-05-18 10:34:20 |
| 768 | 543 | 2 | 2015-05-18 11:16:10 |
| 769 | 544 | 2 | 2015-05-18 11:21:23 |
| 770 | 542 | 3 | 2015-05-18 11:53:24 |
| 771 | 543 | 3 | 2015-05-18 12:23:10 |
| 772 | 544 | 3 | 2015-05-18 12:41:01 |
| 773 | 542 | 1 | 2015-05-18 13:17:14 |
| 774 | 545 | 2 | 2015-05-18 14:22:52 |
| 775 | 506 | 3 | 2015-05-18 14:25:31 |
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;