Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,776–3,800 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3776 | 1975 | 3 | 2016-03-20 09:53:26 |
| 3777 | 1973 | 3 | 2016-03-20 09:55:53 |
| 3778 | 1973 | 2 | 2016-03-20 10:22:44 |
| 3779 | 1974 | 3 | 2016-03-20 10:34:33 |
| 3780 | 1968 | 2 | 2016-03-20 10:39:15 |
| 3781 | 1967 | 2 | 2016-03-20 10:47:14 |
| 3782 | 1974 | 2 | 2016-03-20 11:13:58 |
| 3783 | 1973 | 3 | 2016-03-20 11:35:08 |
| 3784 | 1881 | 3 | 2016-03-20 11:39:09 |
| 3785 | 1880 | 3 | 2016-03-20 11:39:53 |
| 3786 | 1880 | 1 | 2016-03-20 12:51:17 |
| 3787 | 1881 | 1 | 2016-03-20 13:06:28 |
| 3788 | 1954 | 2 | 2016-03-21 14:58:19 |
| 3789 | 1952 | 2 | 2016-03-21 14:58:55 |
| 3790 | 1953 | 2 | 2016-03-21 15:00:22 |
| 3791 | 1951 | 2 | 2016-03-21 15:06:57 |
| 3792 | 1950 | 2 | 2016-03-21 15:14:10 |
| 3793 | 1954 | 3 | 2016-03-21 15:27:33 |
| 3794 | 1952 | 3 | 2016-03-21 15:29:55 |
| 3795 | 1979 | 1 | 2016-03-21 15:34:09 |
| 3796 | 1980 | 1 | 2016-03-21 15:37:44 |
| 3797 | 1953 | 3 | 2016-03-21 15:44:23 |
| 3798 | 1950 | 3 | 2016-03-21 15:50:14 |
| 3799 | 1951 | 3 | 2016-03-21 16:31:17 |
| 3800 | 1953 | 1 | 2016-03-21 16:38: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;