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,926–2,950 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 2926 | 3036 | 1 | 2016-11-20 11:48:48 | 1 | Walk |
| 2927 | 3035 | 1 | 2016-11-20 11:48:49 | 1 | Walk |
| 2928 | 3038 | 1 | 2016-11-20 13:08:08 | 1 | Taxi |
| 2929 | 3037 | 1 | 2016-11-20 13:08:26 | 1 | Taxi |
| 2930 | 3039 | 1 | 2016-11-20 13:42:30 | 1 | Bus |
| 2931 | 3039 | 1 | 2016-11-20 16:06:38 | 0 | NULL |
| 2932 | 3040 | 1 | 2016-11-21 14:33:48 | 1 | Metro |
| 2933 | 3041 | 1 | 2016-11-21 14:34:16 | 1 | Metro |
| 2934 | 3042 | 2 | 2016-11-21 15:01:12 | 1 | Metro |
| 2935 | 3045 | 4 | 2016-11-22 14:22:03 | 1 | Metro |
| 2936 | 3046 | 4 | 2016-11-22 14:22:18 | 1 | Metro |
| 2937 | 3043 | 4 | 2016-11-22 14:22:25 | 1 | Metro |
| 2938 | 3044 | 4 | 2016-11-22 14:22:31 | 1 | Metro |
| 2939 | 3029 | 2 | 2016-11-23 10:06:26 | 1 | Metro |
| 2940 | 3030 | 2 | 2016-11-23 10:06:30 | 1 | Metro |
| 2941 | 3028 | 2 | 2016-11-23 10:07:14 | 1 | Metro |
| 2942 | 3047 | 4 | 2016-11-23 10:20:46 | 1 | Walk |
| 2943 | 3049 | 1 | 2016-11-24 10:20:00 | 1 | Walk |
| 2944 | 3051 | 1 | 2016-11-24 10:20:06 | 1 | Walk |
| 2945 | 3050 | 1 | 2016-11-24 10:20:36 | 1 | Walk |
| 2946 | 3052 | 2 | 2016-11-24 11:29:05 | 1 | Metro |
| 2947 | 3012 | 4 | 2016-11-24 14:32:35 | 1 | Walk |
| 2948 | 3053 | 5 | 2016-11-25 10:18:25 | 1 | Walk |
| 2949 | 3054 | 5 | 2016-11-25 10:19:03 | 1 | Walk |
| 2950 | 3060 | 1 | 2016-11-25 14:44:51 | 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;