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,876–2,900 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 2876 | 2939 | 2 | 2016-11-04 16:49:29 | 1 | Metro |
| 2877 | 2937 | 2 | 2016-11-04 16:49:39 | 1 | Metro |
| 2878 | 2938 | 2 | 2016-11-04 16:50:09 | 1 | Metro |
| 2879 | 2995 | 1 | 2016-11-05 10:57:56 | 1 | Walk |
| 2880 | 2996 | 1 | 2016-11-05 10:58:15 | 1 | Walk |
| 2881 | 2940 | 1 | 2016-11-06 11:06:34 | 1 | Metro |
| 2882 | 2945 | 5 | 2016-11-06 14:30:55 | 1 | Walk |
| 2883 | 2944 | 5 | 2016-11-06 14:31:12 | 1 | Walk |
| 2884 | 3001 | 1 | 2016-11-07 09:19:55 | 1 | Train |
| 2885 | 3002 | 1 | 2016-11-07 09:20:20 | 1 | Train |
| 2886 | 3000 | 1 | 2016-11-07 09:20:21 | 1 | Train |
| 2887 | 2992 | 3 | 2016-11-08 11:32:36 | 1 | Walk |
| 2888 | 2991 | 3 | 2016-11-08 11:32:43 | 1 | Walk |
| 2889 | 3006 | 4 | 2016-11-08 11:42:06 | 1 | Walk |
| 2890 | 3008 | 4 | 2016-11-08 11:42:09 | 1 | Walk |
| 2891 | 3007 | 4 | 2016-11-08 11:42:26 | 1 | Walk |
| 2892 | 3005 | 4 | 2016-11-08 11:42:33 | 1 | Walk |
| 2893 | 3004 | 1 | 2016-11-09 11:55:51 | 1 | Other |
| 2894 | 3003 | 1 | 2016-11-09 11:55:53 | 1 | Other |
| 2895 | 2997 | 1 | 2016-11-10 11:40:45 | 1 | Bus |
| 2896 | 2931 | 3 | 2016-11-11 13:13:34 | 1 | Metro |
| 2897 | 2930 | 3 | 2016-11-11 13:13:44 | 1 | Metro |
| 2898 | 2929 | 3 | 2016-11-11 13:13:59 | 1 | Metro |
| 2899 | 2932 | 3 | 2016-11-11 13:14:07 | 1 | Metro |
| 2900 | 3013 | 2 | 2016-11-11 14:38:09 | 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;