Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 8,926–8,950 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 8926 | 9240 | 3 | 2019-10-19 10:40:24 | 1 | Walk |
| 8927 | 9158 | 1 | 2019-10-19 14:32:22 | 1 | Walk |
| 8928 | 9156 | 1 | 2019-10-19 14:32:23 | 1 | Walk |
| 8929 | 9157 | 1 | 2019-10-19 14:32:54 | 1 | Walk |
| 8930 | 9159 | 1 | 2019-10-19 14:32:54 | 1 | Walk |
| 8931 | 9144 | 1 | 2019-10-20 11:58:50 | 1 | Metro |
| 8932 | 9295 | 3 | 2019-10-22 11:40:18 | 1 | Walk |
| 8933 | 9299 | 2 | 2019-10-23 09:44:30 | 1 | Private Vehicle |
| 8934 | 9298 | 2 | 2019-10-23 09:44:54 | 1 | Private Vehicle |
| 8935 | 9232 | 2 | 2019-10-23 10:56:20 | 1 | Private Vehicle |
| 8936 | 9233 | 2 | 2019-10-23 10:56:30 | 1 | Private Vehicle |
| 8937 | 9231 | 2 | 2019-10-23 10:56:46 | 1 | Private Vehicle |
| 8938 | 9230 | 2 | 2019-10-23 10:56:55 | 1 | Private Vehicle |
| 8939 | 9302 | 1 | 2019-10-23 14:00:28 | 1 | Walk |
| 8940 | 9153 | 4 | 2019-10-24 13:20:32 | 1 | Metro |
| 8941 | 9152 | 4 | 2019-10-24 13:20:47 | 1 | Metro |
| 8942 | 9170 | 3 | 2019-10-24 14:06:29 | 1 | Bus |
| 8943 | 9305 | 2 | 2019-10-25 09:36:30 | 1 | Metro |
| 8944 | 9304 | 2 | 2019-10-25 09:36:51 | 1 | Metro |
| 8945 | 9293 | 1 | 2019-10-25 13:54:50 | 1 | Walk |
| 8946 | 9294 | 1 | 2019-10-25 13:55:16 | 1 | Walk |
| 8947 | 9163 | 5 | 2019-10-25 15:49:00 | 1 | Walk |
| 8948 | 9027 | 4 | 2019-10-26 09:19:46 | 1 | Metro |
| 8949 | 9029 | 4 | 2019-10-26 09:20:00 | 1 | Metro |
| 8950 | 9031 | 4 | 2019-10-26 09:20:04 | 1 | Metro |
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;