Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,776–6,800 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6776 | 3581 | 2 | 2017-03-08 10:13:27 |
| 6777 | 3563 | 2 | 2017-03-08 11:07:11 |
| 6778 | 3582 | 1 | 2017-03-08 11:07:24 |
| 6779 | 3581 | 1 | 2017-03-08 11:16:50 |
| 6780 | 3605 | 1 | 2017-03-08 11:24:49 |
| 6781 | 3563 | 3 | 2017-03-08 11:43:44 |
| 6782 | 3581 | 2 | 2017-03-08 11:50:16 |
| 6783 | 3582 | 2 | 2017-03-08 12:24:11 |
| 6784 | 3581 | 3 | 2017-03-08 13:10:48 |
| 6785 | 3582 | 3 | 2017-03-08 13:46:47 |
| 6786 | 3607 | 2 | 2017-03-08 13:58:30 |
| 6787 | 3608 | 2 | 2017-03-08 14:08:27 |
| 6788 | 3611 | 2 | 2017-03-10 12:47:41 |
| 6789 | 3610 | 2 | 2017-03-10 12:50:15 |
| 6790 | 3611 | 3 | 2017-03-10 13:18:30 |
| 6791 | 3610 | 3 | 2017-03-10 13:33:46 |
| 6792 | 3611 | 2 | 2017-03-10 14:16:36 |
| 6793 | 3610 | 2 | 2017-03-10 14:37:37 |
| 6794 | 3611 | 1 | 2017-03-10 14:59:15 |
| 6795 | 3538 | 2 | 2017-03-10 15:57:00 |
| 6796 | 3537 | 2 | 2017-03-10 16:01:59 |
| 6797 | 3610 | 1 | 2017-03-10 16:08:10 |
| 6798 | 3538 | 1 | 2017-03-10 17:00:47 |
| 6799 | 3537 | 3 | 2017-03-10 17:16:25 |
| 6800 | 3565 | 2 | 2017-03-11 11:52:59 |
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;