Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,951–1,975 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1951 | 1065 | 2 | 2015-09-02 13:49:23 |
| 1952 | 1065 | 3 | 2015-09-02 14:31:41 |
| 1953 | 1066 | 3 | 2015-09-02 14:38:55 |
| 1954 | 1065 | 1 | 2015-09-02 15:10:48 |
| 1955 | 1066 | 1 | 2015-09-02 16:09:56 |
| 1956 | 1053 | 3 | 2015-09-02 16:38:38 |
| 1957 | 1054 | 3 | 2015-09-02 16:38:55 |
| 1958 | 1052 | 3 | 2015-09-02 16:50:02 |
| 1959 | 1054 | 1 | 2015-09-02 17:23:46 |
| 1960 | 1006 | 3 | 2015-09-03 11:03:23 |
| 1961 | 1008 | 2 | 2015-09-03 11:05:28 |
| 1962 | 1007 | 3 | 2015-09-03 11:05:43 |
| 1963 | 1005 | 3 | 2015-09-03 11:11:55 |
| 1964 | 1005 | 1 | 2015-09-03 11:44:34 |
| 1965 | 1007 | 1 | 2015-09-03 11:46:46 |
| 1966 | 1008 | 1 | 2015-09-03 12:02:00 |
| 1967 | 563 | 3 | 2015-09-03 12:05:19 |
| 1968 | 552 | 3 | 2015-09-03 12:08:48 |
| 1969 | 588 | 3 | 2015-09-03 12:09:19 |
| 1970 | 561 | 3 | 2015-09-03 12:09:39 |
| 1971 | 553 | 3 | 2015-09-03 12:10:49 |
| 1972 | 557 | 3 | 2015-09-03 12:11:07 |
| 1973 | 558 | 3 | 2015-09-03 12:12:18 |
| 1974 | 592 | 3 | 2015-09-03 12:13:55 |
| 1975 | 565 | 3 | 2015-09-03 12:13: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;