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,226–2,250 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 2226 | 2387 | 2 | 2016-06-18 11:55:34 | 1 | Private Vehicle |
| 2227 | 2388 | 2 | 2016-06-18 11:55:44 | 1 | Private Vehicle |
| 2228 | 2391 | 1 | 2016-06-19 14:27:52 | 1 | Taxi |
| 2229 | 2392 | 1 | 2016-06-19 14:27:55 | 1 | Taxi |
| 2230 | 2394 | 2 | 2016-06-20 10:35:45 | 1 | Taxi |
| 2231 | 2393 | 2 | 2016-06-20 10:36:04 | 1 | Taxi |
| 2232 | 2395 | 2 | 2016-06-20 10:36:25 | 1 | Taxi |
| 2233 | 2209 | 1 | 2016-06-22 09:32:26 | 1 | Walk |
| 2234 | 2210 | 1 | 2016-06-22 09:32:40 | 1 | Walk |
| 2235 | 2212 | 1 | 2016-06-22 09:32:50 | 1 | Walk |
| 2236 | 2213 | 1 | 2016-06-22 09:32:59 | 1 | Walk |
| 2237 | 2226 | 1 | 2016-06-22 09:33:14 | 1 | Walk |
| 2238 | 2222 | 1 | 2016-06-22 09:33:20 | 1 | Walk |
| 2239 | 2227 | 1 | 2016-06-22 09:33:20 | 1 | Walk |
| 2240 | 2214 | 1 | 2016-06-22 09:33:26 | 1 | Walk |
| 2241 | 2217 | 1 | 2016-06-22 09:33:26 | 1 | Walk |
| 2242 | 2228 | 1 | 2016-06-22 09:33:26 | 1 | Walk |
| 2243 | 2233 | 1 | 2016-06-22 09:33:26 | 1 | Walk |
| 2244 | 2235 | 1 | 2016-06-22 09:33:36 | 1 | Walk |
| 2245 | 2240 | 1 | 2016-06-22 09:33:38 | 1 | Walk |
| 2246 | 2223 | 1 | 2016-06-22 09:34:11 | 1 | Walk |
| 2247 | 2236 | 1 | 2016-06-22 09:34:11 | 1 | Walk |
| 2248 | 2232 | 1 | 2016-06-22 09:35:00 | 1 | Walk |
| 2249 | 2234 | 1 | 2016-06-22 09:35:41 | 1 | Walk |
| 2250 | 2238 | 1 | 2016-06-22 09:35:54 | 1 | Walk |
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;