Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 4,051–4,075 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 4051 | 4140 | 4 | 2017-07-06 15:08:54 | 1 | Metro |
| 4052 | 4185 | 3 | 2017-07-07 10:27:37 | 1 | Metro |
| 4053 | 4184 | 3 | 2017-07-07 10:28:18 | 1 | Metro |
| 4054 | 4087 | 3 | 2017-07-07 13:28:59 | 1 | Metro |
| 4055 | 4088 | 3 | 2017-07-07 13:29:14 | 1 | Metro |
| 4056 | 4190 | 1 | 2017-07-08 11:50:31 | 1 | Walk |
| 4057 | 4191 | 1 | 2017-07-08 11:50:34 | 1 | Walk |
| 4058 | 4188 | 1 | 2017-07-08 11:50:42 | 1 | Walk |
| 4059 | 4189 | 1 | 2017-07-08 11:50:49 | 1 | Walk |
| 4060 | 4187 | 1 | 2017-07-08 11:50:57 | 1 | Walk |
| 4061 | 4179 | 4 | 2017-07-08 12:58:43 | 1 | Bus |
| 4062 | 4178 | 4 | 2017-07-08 12:59:12 | 1 | Bus |
| 4063 | 4183 | 1 | 2017-07-08 13:35:50 | 1 | Walk |
| 4064 | 4182 | 1 | 2017-07-08 13:36:18 | 1 | Walk |
| 4065 | 4180 | 3 | 2017-07-09 09:12:01 | 1 | Metro |
| 4066 | 4193 | 5 | 2017-07-09 13:44:06 | 1 | Train |
| 4067 | 4194 | 3 | 2017-07-09 13:55:12 | 1 | Metro |
| 4068 | 4195 | 3 | 2017-07-09 13:55:49 | 1 | Metro |
| 4069 | 4243 | 1 | 2017-07-11 11:54:11 | 1 | Walk |
| 4070 | 4244 | 1 | 2017-07-11 11:54:45 | 1 | Walk |
| 4071 | 4100 | 1 | 2017-07-12 10:31:47 | 1 | Walk |
| 4072 | 4099 | 1 | 2017-07-12 10:32:11 | 1 | Walk |
| 4073 | 4172 | 2 | 2017-07-12 11:50:47 | 1 | Metro |
| 4074 | 4173 | 2 | 2017-07-12 11:51:25 | 1 | Metro |
| 4075 | 4171 | 2 | 2017-07-13 09:55:07 | 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;