Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,776–12,800 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12776 | 5913 | 3 | 2018-08-27 14:23:36 |
| 12777 | 5928 | 3 | 2018-08-27 14:53:37 |
| 12778 | 6567 | 2 | 2018-08-27 16:01:29 |
| 12779 | 6567 | 1 | 2018-08-27 16:54:47 |
| 12780 | 6573 | 2 | 2018-08-29 11:48:40 |
| 12781 | 6573 | 3 | 2018-08-29 12:17:07 |
| 12782 | 6469 | 1 | 2018-08-29 12:21:20 |
| 12783 | 6470 | 1 | 2018-08-29 12:27:33 |
| 12784 | 6469 | 3 | 2018-08-29 12:57:05 |
| 12785 | 6470 | 2 | 2018-08-29 13:19:29 |
| 12786 | 5835 | 2 | 2018-08-29 13:57:39 |
| 12787 | 5854 | 2 | 2018-08-29 13:58:29 |
| 12788 | 5855 | 2 | 2018-08-29 13:58:32 |
| 12789 | 5852 | 2 | 2018-08-29 13:58:55 |
| 12790 | 5837 | 2 | 2018-08-29 13:59:03 |
| 12791 | 5847 | 2 | 2018-08-29 13:59:26 |
| 12792 | 5856 | 2 | 2018-08-29 13:59:47 |
| 12793 | 5844 | 2 | 2018-08-29 14:00:51 |
| 12794 | 5834 | 2 | 2018-08-29 14:01:31 |
| 12795 | 5841 | 2 | 2018-08-29 14:01:37 |
| 12796 | 5860 | 2 | 2018-08-29 14:02:07 |
| 12797 | 5839 | 2 | 2018-08-29 14:02:40 |
| 12798 | 5859 | 2 | 2018-08-29 14:03:23 |
| 12799 | 5849 | 2 | 2018-08-29 14:03:30 |
| 12800 | 5853 | 2 | 2018-08-29 14:03:57 |
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;