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,176–3,200 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 3176 | 3400 | 3 | 2017-01-28 10:35:46 | 1 | Walk |
| 3177 | 3398 | 3 | 2017-01-28 10:36:00 | 1 | Walk |
| 3178 | 3399 | 3 | 2017-01-28 10:36:03 | 1 | Walk |
| 3179 | 3493 | 2 | 2017-01-31 11:12:54 | 1 | Metro |
| 3180 | 3476 | 1 | 2017-02-01 10:47:13 | 1 | Metro |
| 3181 | 3475 | 1 | 2017-02-01 10:47:45 | 1 | Metro |
| 3182 | 3474 | 1 | 2017-02-01 10:47:49 | 1 | Metro |
| 3183 | 3477 | 1 | 2017-02-01 10:47:59 | 1 | Metro |
| 3184 | 3497 | 5 | 2017-02-03 14:58:36 | 1 | Train |
| 3185 | 3498 | 5 | 2017-02-03 14:59:16 | 1 | Train |
| 3186 | 3504 | 2 | 2017-02-05 11:08:19 | 1 | Walk |
| 3187 | 3503 | 2 | 2017-02-05 11:08:36 | 1 | Walk |
| 3188 | 3507 | 2 | 2017-02-05 11:11:36 | 1 | Private Vehicle |
| 3189 | 3506 | 2 | 2017-02-05 11:11:39 | 1 | Private Vehicle |
| 3190 | 3505 | 2 | 2017-02-05 11:12:00 | 1 | Private Vehicle |
| 3191 | 3513 | 1 | 2017-02-06 09:08:04 | 1 | Walk |
| 3192 | 3481 | 1 | 2017-02-06 11:33:01 | 1 | Metro |
| 3193 | 3480 | 1 | 2017-02-06 11:33:03 | 1 | Metro |
| 3194 | 3495 | 4 | 2017-02-07 10:29:07 | 1 | Walk |
| 3195 | 3496 | 4 | 2017-02-07 10:29:19 | 1 | Walk |
| 3196 | 3482 | 1 | 2017-02-08 10:31:28 | 1 | Metro |
| 3197 | 3521 | 1 | 2017-02-11 11:42:59 | 1 | Metro |
| 3198 | 3522 | 1 | 2017-02-11 11:43:31 | 1 | Metro |
| 3199 | 3524 | 1 | 2017-02-11 13:53:01 | 1 | Walk |
| 3200 | 3523 | 1 | 2017-02-11 13:53:12 | 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;