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,351–3,375 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 3351 | 3599 | 3 | 2017-03-13 09:43:24 | 1 | Walk |
| 3352 | 3600 | 3 | 2017-03-13 09:43:45 | 1 | Walk |
| 3353 | 3618 | 3 | 2017-03-14 09:55:35 | 1 | Walk |
| 3354 | 3342 | 4 | 2017-03-14 11:02:59 | 1 | Walk |
| 3355 | 3344 | 4 | 2017-03-14 11:03:07 | 1 | Walk |
| 3356 | 3343 | 4 | 2017-03-14 11:03:14 | 1 | Walk |
| 3357 | 3348 | 4 | 2017-03-14 11:03:29 | 1 | Walk |
| 3358 | 3345 | 4 | 2017-03-14 11:03:35 | 1 | Walk |
| 3359 | 3346 | 4 | 2017-03-14 11:03:59 | 1 | Walk |
| 3360 | 3350 | 4 | 2017-03-14 11:04:02 | 1 | Walk |
| 3361 | 3356 | 4 | 2017-03-14 11:04:04 | 1 | Walk |
| 3362 | 3349 | 4 | 2017-03-14 11:04:11 | 1 | Walk |
| 3363 | 3362 | 4 | 2017-03-14 11:04:34 | 1 | Walk |
| 3364 | 3352 | 4 | 2017-03-14 11:04:38 | 1 | Walk |
| 3365 | 3366 | 4 | 2017-03-14 11:04:44 | 1 | Walk |
| 3366 | 3351 | 4 | 2017-03-14 11:04:59 | 1 | Walk |
| 3367 | 3353 | 4 | 2017-03-14 11:04:59 | 1 | Walk |
| 3368 | 3358 | 4 | 2017-03-14 11:04:59 | 1 | Walk |
| 3369 | 3354 | 4 | 2017-03-14 11:05:00 | 1 | Walk |
| 3370 | 3361 | 4 | 2017-03-14 11:05:23 | 1 | Walk |
| 3371 | 3370 | 4 | 2017-03-14 11:05:29 | 1 | Walk |
| 3372 | 3355 | 4 | 2017-03-14 11:05:47 | 1 | Walk |
| 3373 | 3357 | 4 | 2017-03-14 11:06:01 | 1 | Walk |
| 3374 | 3369 | 4 | 2017-03-14 11:06:11 | 1 | Walk |
| 3375 | 3367 | 4 | 2017-03-14 11:06:39 | 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;