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,126–3,150 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 3126 | 3390 | 1 | 2017-01-08 12:05:14 | 1 | Walk |
| 3127 | 3389 | 1 | 2017-01-08 12:05:23 | 1 | Walk |
| 3128 | 3338 | 2 | 2017-01-10 11:58:23 | 1 | Private Vehicle |
| 3129 | 3337 | 2 | 2017-01-10 11:58:40 | 1 | Private Vehicle |
| 3130 | 3391 | 1 | 2017-01-10 16:29:14 | 1 | Walk |
| 3131 | 3392 | 1 | 2017-01-10 16:29:23 | 1 | Walk |
| 3132 | 3336 | 2 | 2017-01-11 13:15:34 | 1 | Metro |
| 3133 | 3334 | 5 | 2017-01-12 11:56:51 | 1 | Walk |
| 3134 | 3333 | 5 | 2017-01-12 11:57:02 | 1 | Walk |
| 3135 | 3395 | 3 | 2017-01-12 14:52:20 | 1 | Other |
| 3136 | 3396 | 3 | 2017-01-12 14:52:42 | 1 | Other |
| 3137 | 3397 | 3 | 2017-01-12 14:52:49 | 1 | Other |
| 3138 | 3402 | 1 | 2017-01-14 12:17:51 | 1 | Train |
| 3139 | 3401 | 1 | 2017-01-14 12:18:07 | 1 | Train |
| 3140 | 3403 | 1 | 2017-01-14 15:52:12 | 1 | Walk |
| 3141 | 3407 | 4 | 2017-01-16 11:05:51 | 1 | Walk |
| 3142 | 3406 | 4 | 2017-01-16 11:06:19 | 1 | Walk |
| 3143 | 3393 | 1 | 2017-01-17 13:58:18 | 1 | Walk |
| 3144 | 3410 | 2 | 2017-01-17 14:21:55 | 1 | Metro |
| 3145 | 3411 | 2 | 2017-01-17 14:22:31 | 1 | Metro |
| 3146 | 3408 | 1 | 2017-01-18 12:43:56 | 1 | Metro |
| 3147 | 3409 | 1 | 2017-01-18 12:44:44 | 1 | Metro |
| 3148 | 3394 | 1 | 2017-01-19 10:59:43 | 1 | Train |
| 3149 | 3422 | 1 | 2017-01-20 14:19:24 | 1 | Metro |
| 3150 | 3421 | 1 | 2017-01-20 14:19:42 | 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;