Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 3,026–3,050 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 3026 | 3239 | 5 | 2016-12-19 13:30:27 | 1 | Walk |
| 3027 | 3176 | 1 | 2016-12-21 11:47:24 | 1 | Train |
| 3028 | 3174 | 1 | 2016-12-21 11:47:25 | 1 | Train |
| 3029 | 3175 | 1 | 2016-12-21 11:47:33 | 1 | Train |
| 3030 | 3243 | 1 | 2016-12-23 09:30:34 | 1 | Walk |
| 3031 | 3242 | 1 | 2016-12-23 09:31:11 | 1 | Walk |
| 3032 | 3244 | 1 | 2016-12-23 14:26:53 | 1 | Train |
| 3033 | 3247 | 1 | 2016-12-23 14:27:17 | 1 | Train |
| 3034 | 3246 | 1 | 2016-12-23 14:27:26 | 1 | Train |
| 3035 | 3245 | 1 | 2016-12-23 14:27:31 | 1 | Train |
| 3036 | 3252 | 5 | 2016-12-24 10:24:50 | 1 | Walk |
| 3037 | 3251 | 5 | 2016-12-24 10:24:52 | 1 | Walk |
| 3038 | 3149 | 1 | 2016-12-24 12:11:20 | 1 | Walk |
| 3039 | 3307 | 4 | 2016-12-25 12:27:12 | 1 | Walk |
| 3040 | 3304 | 4 | 2016-12-25 12:27:20 | 1 | Walk |
| 3041 | 3306 | 4 | 2016-12-25 12:27:41 | 1 | Walk |
| 3042 | 3305 | 4 | 2016-12-25 12:27:42 | 1 | Walk |
| 3043 | 3303 | 4 | 2016-12-25 12:27:50 | 1 | Walk |
| 3044 | 3152 | 1 | 2016-12-25 13:27:05 | 1 | Metro |
| 3045 | 3154 | 1 | 2016-12-25 13:27:41 | 1 | Metro |
| 3046 | 3153 | 1 | 2016-12-25 13:27:50 | 1 | Metro |
| 3047 | 3155 | 1 | 2016-12-25 13:27:51 | 1 | Metro |
| 3048 | 2953 | 4 | 2016-12-26 09:37:59 | 1 | Bus |
| 3049 | 2954 | 4 | 2016-12-26 09:38:11 | 1 | Bus |
| 3050 | 2955 | 4 | 2016-12-26 09:38:11 | 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;