Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 2,126–2,150 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 2126 | 2180 | 4 | 2016-05-29 12:05:25 | 1 | Bus |
| 2127 | 2191 | 4 | 2016-05-29 12:05:31 | 1 | Bus |
| 2128 | 2185 | 4 | 2016-05-29 12:05:45 | 1 | Bus |
| 2129 | 2189 | 4 | 2016-05-29 12:05:46 | 1 | Bus |
| 2130 | 2183 | 4 | 2016-05-29 12:05:51 | 1 | Bus |
| 2131 | 2179 | 4 | 2016-05-29 12:06:06 | 1 | Bus |
| 2132 | 2190 | 4 | 2016-05-29 12:07:09 | 1 | Bus |
| 2133 | 2197 | 4 | 2016-05-29 12:08:14 | 1 | Bus |
| 2134 | 2196 | 4 | 2016-05-29 12:08:41 | 1 | Bus |
| 2135 | 2203 | 1 | 2016-05-29 12:13:33 | 1 | Metro |
| 2136 | 2202 | 1 | 2016-05-29 12:14:12 | 1 | Metro |
| 2137 | 2204 | 1 | 2016-05-29 12:14:16 | 1 | Metro |
| 2138 | 2302 | 3 | 2016-05-29 12:51:24 | 1 | Metro |
| 2139 | 2303 | 3 | 2016-05-29 12:52:09 | 1 | Metro |
| 2140 | 2286 | 1 | 2016-05-29 14:43:19 | 1 | Walk |
| 2141 | 2285 | 1 | 2016-05-29 14:43:41 | 1 | Walk |
| 2142 | 2306 | 2 | 2016-05-29 15:49:46 | 1 | Walk |
| 2143 | 2305 | 2 | 2016-05-29 15:49:57 | 1 | Walk |
| 2144 | 2304 | 2 | 2016-05-29 15:50:13 | 1 | Walk |
| 2145 | 2312 | 1 | 2016-06-01 10:11:18 | 1 | Walk |
| 2146 | 2311 | 1 | 2016-06-01 10:11:30 | 1 | Walk |
| 2147 | 2314 | 3 | 2016-06-01 14:16:45 | 1 | Metro |
| 2148 | 2315 | 3 | 2016-06-01 14:16:59 | 1 | Metro |
| 2149 | 2313 | 3 | 2016-06-01 14:17:06 | 1 | Metro |
| 2150 | 2317 | 3 | 2016-06-01 14:17:08 | 1 | Metro |
Table definition
CREATE TABLE entry_scan (
scan_id INTEGER PRIMARY KEY,
ticket_id INTEGER NOT NULL REFERENCES ticket (ticket_id),
entrance_id INTEGER NOT NULL REFERENCES entrance (entrance_id),
scanned_at TEXT NOT NULL,
is_first_entry INTEGER NOT NULL CHECK (is_first_entry IN (0, 1)),
transport_mode TEXT CHECK (transport_mode IN ('Walk', 'Metro', 'Train', 'Bus', 'Taxi', 'Private Vehicle', 'Other')),
CHECK ((is_first_entry = 1) = (transport_mode IS NOT NULL))
) STRICT;