Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 3,151–3,175 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 3151 | 3420 | 1 | 2017-01-20 14:19:55 | 1 | Metro |
| 3152 | 3405 | 3 | 2017-01-21 10:05:58 | 1 | Walk |
| 3153 | 3404 | 3 | 2017-01-21 10:06:26 | 1 | Walk |
| 3154 | 3412 | 4 | 2017-01-22 11:20:24 | 1 | Walk |
| 3155 | 3472 | 1 | 2017-01-23 12:07:50 | 1 | Walk |
| 3156 | 3471 | 1 | 2017-01-23 12:08:28 | 1 | Walk |
| 3157 | 3423 | 1 | 2017-01-24 10:01:46 | 1 | Walk |
| 3158 | 3413 | 2 | 2017-01-26 10:35:50 | 1 | Walk |
| 3159 | 3414 | 2 | 2017-01-26 10:35:55 | 1 | Walk |
| 3160 | 3415 | 1 | 2017-01-26 11:00:50 | 1 | Metro |
| 3161 | 3417 | 1 | 2017-01-26 11:00:57 | 1 | Metro |
| 3162 | 3416 | 1 | 2017-01-26 11:01:00 | 1 | Metro |
| 3163 | 3418 | 1 | 2017-01-26 11:01:26 | 1 | Metro |
| 3164 | 3419 | 1 | 2017-01-26 11:01:30 | 1 | Metro |
| 3165 | 3483 | 5 | 2017-01-26 13:35:51 | 1 | Bus |
| 3166 | 3484 | 5 | 2017-01-27 09:14:08 | 1 | Bus |
| 3167 | 3485 | 3 | 2017-01-27 10:08:35 | 1 | Other |
| 3168 | 3486 | 5 | 2017-01-27 11:01:07 | 1 | Metro |
| 3169 | 3487 | 5 | 2017-01-27 11:01:23 | 1 | Metro |
| 3170 | 3478 | 3 | 2017-01-27 13:22:43 | 1 | Walk |
| 3171 | 3479 | 3 | 2017-01-27 13:22:43 | 1 | Walk |
| 3172 | 3488 | 4 | 2017-01-27 15:25:19 | 1 | Walk |
| 3173 | 3489 | 4 | 2017-01-27 15:25:28 | 1 | Walk |
| 3174 | 3491 | 4 | 2017-01-27 15:25:44 | 1 | Walk |
| 3175 | 3490 | 4 | 2017-01-27 15:25:50 | 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;