Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 9,176–9,200 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 9176 | 9382 | 2 | 2019-11-14 14:09:41 | 1 | Taxi |
| 9177 | 9380 | 2 | 2019-11-15 10:55:11 | 1 | Metro |
| 9178 | 9379 | 2 | 2019-11-15 10:55:35 | 1 | Metro |
| 9179 | 9413 | 1 | 2019-11-15 15:26:20 | 1 | Private Vehicle |
| 9180 | 9406 | 4 | 2019-11-16 09:34:42 | 1 | Taxi |
| 9181 | 9404 | 4 | 2019-11-16 09:34:50 | 1 | Taxi |
| 9182 | 9405 | 4 | 2019-11-16 09:35:13 | 1 | Taxi |
| 9183 | 9407 | 4 | 2019-11-16 09:35:22 | 1 | Taxi |
| 9184 | 9365 | 1 | 2019-11-16 12:59:26 | 1 | Taxi |
| 9185 | 9363 | 1 | 2019-11-16 12:59:48 | 1 | Taxi |
| 9186 | 9415 | 4 | 2019-11-16 13:53:12 | 1 | Walk |
| 9187 | 9416 | 4 | 2019-11-16 13:53:22 | 1 | Walk |
| 9188 | 9420 | 4 | 2019-11-17 09:59:29 | 1 | Other |
| 9189 | 9419 | 4 | 2019-11-17 10:00:15 | 1 | Other |
| 9190 | 9408 | 2 | 2019-11-17 11:38:26 | 1 | Metro |
| 9191 | 9409 | 2 | 2019-11-17 11:38:52 | 1 | Metro |
| 9192 | 9181 | 1 | 2019-11-17 14:16:32 | 1 | Other |
| 9193 | 9180 | 1 | 2019-11-17 14:16:45 | 1 | Other |
| 9194 | 9403 | 1 | 2019-11-18 13:34:44 | 1 | Walk |
| 9195 | 9425 | 1 | 2019-11-19 09:58:32 | 1 | Train |
| 9196 | 9424 | 1 | 2019-11-19 09:59:09 | 1 | Train |
| 9197 | 9422 | 3 | 2019-11-19 10:08:11 | 1 | Walk |
| 9198 | 9421 | 3 | 2019-11-19 10:08:35 | 1 | Walk |
| 9199 | 9343 | 2 | 2019-11-19 13:31:02 | 1 | Metro |
| 9200 | 9344 | 2 | 2019-11-19 13:31:05 | 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;