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,976–3,000 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 2976 | 3076 | 2 | 2016-12-07 10:45:35 | 1 | Metro |
| 2977 | 3077 | 2 | 2016-12-07 10:45:54 | 1 | Metro |
| 2978 | 3071 | 3 | 2016-12-08 11:05:48 | 1 | Walk |
| 2979 | 3069 | 3 | 2016-12-08 11:06:15 | 1 | Walk |
| 2980 | 3072 | 3 | 2016-12-08 11:06:24 | 1 | Walk |
| 2981 | 3070 | 3 | 2016-12-08 11:06:27 | 1 | Walk |
| 2982 | 3145 | 1 | 2016-12-08 13:11:11 | 1 | Metro |
| 2983 | 3148 | 1 | 2016-12-08 13:11:12 | 1 | Metro |
| 2984 | 3146 | 1 | 2016-12-08 13:11:15 | 1 | Metro |
| 2985 | 3147 | 1 | 2016-12-08 13:11:41 | 1 | Metro |
| 2986 | 3151 | 3 | 2016-12-08 16:46:09 | 1 | Walk |
| 2987 | 3143 | 2 | 2016-12-09 10:01:41 | 1 | Metro |
| 2988 | 3156 | 4 | 2016-12-10 16:36:39 | 1 | Bus |
| 2989 | 3164 | 4 | 2016-12-11 13:47:19 | 1 | Metro |
| 2990 | 3165 | 4 | 2016-12-11 13:47:23 | 1 | Metro |
| 2991 | 3166 | 3 | 2016-12-11 14:18:09 | 1 | Bus |
| 2992 | 3167 | 1 | 2016-12-12 16:48:03 | 1 | Walk |
| 2993 | 3160 | 2 | 2016-12-13 14:34:59 | 1 | Bus |
| 2994 | 3158 | 2 | 2016-12-13 14:35:00 | 1 | Bus |
| 2995 | 3159 | 2 | 2016-12-13 14:35:01 | 1 | Bus |
| 2996 | 3157 | 2 | 2016-12-13 14:35:18 | 1 | Bus |
| 2997 | 3169 | 4 | 2016-12-13 16:31:44 | 1 | Bus |
| 2998 | 3168 | 4 | 2016-12-13 16:31:58 | 1 | Bus |
| 2999 | 3170 | 4 | 2016-12-13 16:32:07 | 1 | Bus |
| 3000 | 3171 | 4 | 2016-12-13 16:32:14 | 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;