Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 776–800 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 776 | 545 | 3 | 2015-05-18 14:50:12 |
| 777 | 301 | 3 | 2015-05-18 14:54:50 |
| 778 | 300 | 2 | 2015-05-18 15:07:38 |
| 779 | 506 | 2 | 2015-05-18 15:23:42 |
| 780 | 301 | 1 | 2015-05-18 15:28:35 |
| 781 | 545 | 1 | 2015-05-18 15:37:16 |
| 782 | 301 | 3 | 2015-05-18 15:55:01 |
| 783 | 506 | 3 | 2015-05-18 16:18:19 |
| 784 | 548 | 2 | 2015-05-20 15:37:37 |
| 785 | 549 | 2 | 2015-05-20 15:37:46 |
| 786 | 550 | 3 | 2015-05-20 15:52:58 |
| 787 | 548 | 3 | 2015-05-20 16:19:01 |
| 788 | 550 | 1 | 2015-05-20 16:26:54 |
| 789 | 548 | 2 | 2015-05-20 17:11:24 |
| 790 | 549 | 3 | 2015-05-20 17:11:32 |
| 791 | 547 | 3 | 2015-05-21 11:40:42 |
| 792 | 546 | 3 | 2015-05-21 11:44:29 |
| 793 | 523 | 2 | 2015-05-21 11:44:56 |
| 794 | 547 | 2 | 2015-05-21 12:11:11 |
| 795 | 546 | 2 | 2015-05-21 13:09:29 |
| 796 | 547 | 3 | 2015-05-21 13:43:53 |
| 797 | 547 | 2 | 2015-05-21 14:12:27 |
| 798 | 601 | 2 | 2015-05-21 14:17:17 |
| 799 | 546 | 3 | 2015-05-21 14:27:17 |
| 800 | 601 | 1 | 2015-05-21 15:21:29 |
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;