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,076–3,100 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 3076 | 2984 | 4 | 2016-12-26 09:43:35 | 1 | Bus |
| 3077 | 2981 | 4 | 2016-12-26 09:43:37 | 1 | Bus |
| 3078 | 2980 | 4 | 2016-12-26 09:43:49 | 1 | Bus |
| 3079 | 2987 | 4 | 2016-12-26 09:44:11 | 1 | Bus |
| 3080 | 2985 | 4 | 2016-12-26 09:44:16 | 1 | Bus |
| 3081 | 3310 | 2 | 2016-12-26 14:30:03 | 1 | Walk |
| 3082 | 3309 | 2 | 2016-12-26 14:30:25 | 1 | Walk |
| 3083 | 3308 | 2 | 2016-12-26 14:30:26 | 1 | Walk |
| 3084 | 3311 | 1 | 2016-12-27 10:33:43 | 1 | Taxi |
| 3085 | 3078 | 2 | 2016-12-27 10:42:51 | 1 | Metro |
| 3086 | 3080 | 2 | 2016-12-27 10:42:53 | 1 | Metro |
| 3087 | 3079 | 2 | 2016-12-27 10:43:37 | 1 | Metro |
| 3088 | 3313 | 2 | 2016-12-27 10:54:26 | 1 | Metro |
| 3089 | 3312 | 2 | 2016-12-27 10:54:29 | 1 | Metro |
| 3090 | 3314 | 1 | 2016-12-27 12:15:38 | 1 | Walk |
| 3091 | 3315 | 1 | 2016-12-27 12:34:12 | 1 | Other |
| 3092 | 3316 | 1 | 2016-12-27 12:34:26 | 1 | Other |
| 3093 | 3319 | 1 | 2016-12-28 09:09:49 | 1 | Walk |
| 3094 | 3302 | 3 | 2016-12-28 11:03:23 | 1 | Walk |
| 3095 | 3016 | 2 | 2016-12-28 14:32:02 | 1 | Metro |
| 3096 | 3015 | 2 | 2016-12-28 14:32:21 | 1 | Metro |
| 3097 | 3322 | 4 | 2016-12-29 10:08:10 | 1 | Walk |
| 3098 | 3324 | 3 | 2016-12-29 11:33:26 | 1 | Metro |
| 3099 | 3323 | 3 | 2016-12-29 11:33:40 | 1 | Metro |
| 3100 | 3331 | 1 | 2016-12-30 11:47:00 | 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;