Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 6,926–6,950 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 6926 | 6956 | 1 | 2018-12-04 13:58:07 | 1 | Bus |
| 6927 | 6966 | 1 | 2018-12-04 13:58:14 | 1 | Bus |
| 6928 | 6971 | 1 | 2018-12-04 13:58:25 | 1 | Bus |
| 6929 | 6961 | 1 | 2018-12-04 13:58:40 | 1 | Bus |
| 6930 | 6957 | 1 | 2018-12-04 13:58:42 | 1 | Bus |
| 6931 | 6972 | 1 | 2018-12-04 13:59:10 | 1 | Bus |
| 6932 | 6969 | 1 | 2018-12-04 13:59:23 | 1 | Bus |
| 6933 | 6975 | 1 | 2018-12-04 13:59:31 | 1 | Bus |
| 6934 | 6976 | 1 | 2018-12-04 13:59:38 | 1 | Bus |
| 6935 | 6996 | 1 | 2018-12-04 13:59:38 | 1 | Bus |
| 6936 | 6997 | 1 | 2018-12-04 13:59:42 | 1 | Bus |
| 6937 | 6974 | 1 | 2018-12-04 13:59:46 | 1 | Bus |
| 6938 | 6973 | 1 | 2018-12-04 13:59:59 | 1 | Bus |
| 6939 | 6965 | 1 | 2018-12-04 14:00:05 | 1 | Bus |
| 6940 | 6986 | 1 | 2018-12-04 14:00:08 | 1 | Bus |
| 6941 | 6968 | 1 | 2018-12-04 14:00:18 | 1 | Bus |
| 6942 | 6992 | 1 | 2018-12-04 14:00:44 | 1 | Bus |
| 6943 | 6970 | 1 | 2018-12-04 14:01:20 | 1 | Bus |
| 6944 | 7000 | 1 | 2018-12-04 14:01:26 | 1 | Bus |
| 6945 | 6987 | 1 | 2018-12-04 14:01:56 | 1 | Bus |
| 6946 | 6977 | 1 | 2018-12-04 14:02:15 | 1 | Bus |
| 6947 | 6988 | 1 | 2018-12-04 14:02:40 | 1 | Bus |
| 6948 | 6983 | 1 | 2018-12-04 14:02:50 | 1 | Bus |
| 6949 | 6989 | 1 | 2018-12-04 14:02:50 | 1 | Bus |
| 6950 | 6980 | 1 | 2018-12-04 14:02:54 | 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;