Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 6,301–6,325 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 6301 | 6559 | 1 | 2018-08-27 10:28:34 | 1 | Walk |
| 6302 | 5737 | 1 | 2018-08-27 10:28:39 | 1 | Bus |
| 6303 | 5733 | 1 | 2018-08-27 10:28:42 | 1 | Bus |
| 6304 | 5718 | 1 | 2018-08-27 10:28:54 | 1 | Bus |
| 6305 | 5719 | 1 | 2018-08-27 10:29:00 | 1 | Bus |
| 6306 | 5728 | 1 | 2018-08-27 10:29:14 | 1 | Bus |
| 6307 | 5722 | 1 | 2018-08-27 10:29:39 | 1 | Bus |
| 6308 | 5723 | 1 | 2018-08-27 10:29:42 | 1 | Bus |
| 6309 | 5735 | 1 | 2018-08-27 10:30:04 | 1 | Bus |
| 6310 | 5730 | 1 | 2018-08-27 10:30:06 | 1 | Bus |
| 6311 | 5729 | 1 | 2018-08-27 10:30:39 | 1 | Bus |
| 6312 | 5732 | 1 | 2018-08-27 10:30:52 | 1 | Bus |
| 6313 | 5736 | 1 | 2018-08-27 10:31:54 | 1 | Bus |
| 6314 | 6567 | 2 | 2018-08-27 15:46:50 | 1 | Private Vehicle |
| 6315 | 6573 | 1 | 2018-08-29 11:37:19 | 1 | Walk |
| 6316 | 6470 | 1 | 2018-08-29 12:08:25 | 1 | Bus |
| 6317 | 6469 | 1 | 2018-08-29 12:08:53 | 1 | Bus |
| 6318 | 5834 | 4 | 2018-08-29 13:45:11 | 1 | Bus |
| 6319 | 5835 | 4 | 2018-08-29 13:45:18 | 1 | Bus |
| 6320 | 5836 | 4 | 2018-08-29 13:45:21 | 1 | Bus |
| 6321 | 5837 | 4 | 2018-08-29 13:45:32 | 1 | Bus |
| 6322 | 5841 | 4 | 2018-08-29 13:45:39 | 1 | Bus |
| 6323 | 5838 | 4 | 2018-08-29 13:45:43 | 1 | Bus |
| 6324 | 5842 | 4 | 2018-08-29 13:45:43 | 1 | Bus |
| 6325 | 5839 | 4 | 2018-08-29 13:45:56 | 1 | Bus |
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;