Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,051–2,075 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2051 | 1077 | 2 | 2015-09-14 15:15:50 |
| 2052 | 1079 | 2 | 2015-09-14 15:20:30 |
| 2053 | 1078 | 2 | 2015-09-14 15:22:51 |
| 2054 | 1076 | 2 | 2015-09-14 15:25:41 |
| 2055 | 1077 | 3 | 2015-09-14 15:42:21 |
| 2056 | 1076 | 3 | 2015-09-14 16:04:35 |
| 2057 | 1078 | 3 | 2015-09-14 16:41:59 |
| 2058 | 1079 | 3 | 2015-09-14 16:44:21 |
| 2059 | 1133 | 1 | 2015-09-16 11:50:53 |
| 2060 | 1132 | 1 | 2015-09-16 11:58:47 |
| 2061 | 1132 | 2 | 2015-09-16 12:52:35 |
| 2062 | 1133 | 2 | 2015-09-16 13:12:20 |
| 2063 | 959 | 2 | 2015-09-16 16:08:52 |
| 2064 | 960 | 3 | 2015-09-16 16:18:13 |
| 2065 | 961 | 3 | 2015-09-16 16:23:15 |
| 2066 | 958 | 3 | 2015-09-16 16:23:49 |
| 2067 | 958 | 1 | 2015-09-16 17:22:59 |
| 2068 | 959 | 1 | 2015-09-16 17:26:58 |
| 2069 | 961 | 1 | 2015-09-16 17:27:23 |
| 2070 | 960 | 1 | 2015-09-16 17:46:48 |
| 2071 | 1082 | 1 | 2015-09-17 11:24:45 |
| 2072 | 1081 | 2 | 2015-09-17 11:33:09 |
| 2073 | 1081 | 1 | 2015-09-17 12:55:12 |
| 2074 | 1081 | 3 | 2015-09-17 14:11:30 |
| 2075 | 1129 | 2 | 2015-09-18 10:45: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;