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,426–3,450 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 3426 | 3290 | 4 | 2017-03-15 11:25:09 | 1 | Walk |
| 3427 | 3300 | 4 | 2017-03-15 11:25:32 | 1 | Walk |
| 3428 | 3277 | 4 | 2017-03-15 11:25:38 | 1 | Walk |
| 3429 | 3291 | 4 | 2017-03-15 11:25:54 | 1 | Walk |
| 3430 | 3288 | 4 | 2017-03-15 11:26:05 | 1 | Walk |
| 3431 | 3299 | 4 | 2017-03-15 11:26:12 | 1 | Walk |
| 3432 | 3275 | 4 | 2017-03-15 11:26:20 | 1 | Walk |
| 3433 | 3287 | 4 | 2017-03-15 11:26:30 | 1 | Walk |
| 3434 | 3278 | 4 | 2017-03-15 11:26:40 | 1 | Walk |
| 3435 | 3292 | 4 | 2017-03-15 11:26:41 | 1 | Walk |
| 3436 | 3283 | 4 | 2017-03-15 11:26:50 | 1 | Walk |
| 3437 | 3298 | 4 | 2017-03-15 11:26:50 | 1 | Walk |
| 3438 | 3286 | 4 | 2017-03-15 11:26:53 | 1 | Walk |
| 3439 | 3293 | 4 | 2017-03-15 11:27:30 | 1 | Walk |
| 3440 | 3289 | 4 | 2017-03-15 11:29:14 | 1 | Walk |
| 3441 | 3297 | 4 | 2017-03-15 11:29:38 | 1 | Walk |
| 3442 | 3294 | 4 | 2017-03-15 11:31:05 | 1 | Walk |
| 3443 | 3301 | 4 | 2017-03-15 11:32:50 | 1 | Walk |
| 3444 | 3579 | 3 | 2017-03-15 14:42:38 | 1 | Bus |
| 3445 | 3580 | 3 | 2017-03-15 14:42:38 | 1 | Bus |
| 3446 | 3576 | 3 | 2017-03-15 14:42:39 | 1 | Bus |
| 3447 | 3578 | 3 | 2017-03-15 14:42:40 | 1 | Bus |
| 3448 | 3577 | 3 | 2017-03-15 14:42:43 | 1 | Bus |
| 3449 | 3424 | 4 | 2017-03-16 13:52:16 | 1 | Walk |
| 3450 | 3616 | 5 | 2017-03-16 14:29:27 | 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;