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,201–2,225 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 2201 | 2326 | 1 | 2016-06-11 13:12:48 | 1 | Walk |
| 2202 | 2366 | 1 | 2016-06-12 10:14:15 | 1 | Taxi |
| 2203 | 2367 | 1 | 2016-06-12 10:14:25 | 1 | Taxi |
| 2204 | 2371 | 2 | 2016-06-12 11:44:20 | 1 | Private Vehicle |
| 2205 | 2365 | 1 | 2016-06-12 13:32:41 | 1 | Train |
| 2206 | 2364 | 1 | 2016-06-12 13:32:48 | 1 | Train |
| 2207 | 2369 | 1 | 2016-06-12 15:21:40 | 1 | Walk |
| 2208 | 2370 | 1 | 2016-06-12 15:21:56 | 1 | Walk |
| 2209 | 2368 | 1 | 2016-06-12 15:22:16 | 1 | Walk |
| 2210 | 2373 | 1 | 2016-06-14 09:04:19 | 1 | Metro |
| 2211 | 2374 | 1 | 2016-06-14 09:04:26 | 1 | Metro |
| 2212 | 2337 | 2 | 2016-06-14 09:24:53 | 1 | Metro |
| 2213 | 2336 | 2 | 2016-06-14 09:25:00 | 1 | Metro |
| 2214 | 2338 | 1 | 2016-06-14 12:19:36 | 1 | Metro |
| 2215 | 2372 | 2 | 2016-06-16 10:11:48 | 1 | Bus |
| 2216 | 2377 | 1 | 2016-06-16 13:10:14 | 1 | Walk |
| 2217 | 2378 | 1 | 2016-06-16 13:10:19 | 1 | Walk |
| 2218 | 2381 | 2 | 2016-06-16 16:27:55 | 1 | Walk |
| 2219 | 2380 | 2 | 2016-06-16 16:28:16 | 1 | Walk |
| 2220 | 2379 | 2 | 2016-06-16 16:28:33 | 1 | Walk |
| 2221 | 2382 | 1 | 2016-06-17 10:16:34 | 1 | Train |
| 2222 | 2383 | 1 | 2016-06-17 10:16:52 | 1 | Train |
| 2223 | 2385 | 1 | 2016-06-17 10:16:54 | 1 | Train |
| 2224 | 2384 | 1 | 2016-06-17 10:17:09 | 1 | Train |
| 2225 | 2389 | 2 | 2016-06-18 11:55:14 | 1 | Private Vehicle |
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;