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,301–3,325 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 3301 | 3575 | 1 | 2017-03-01 10:40:03 | 1 | Walk |
| 3302 | 3574 | 1 | 2017-03-01 10:40:04 | 1 | Walk |
| 3303 | 3558 | 4 | 2017-03-01 13:30:33 | 1 | Bus |
| 3304 | 3512 | 1 | 2017-03-02 11:32:11 | 1 | Bus |
| 3305 | 3511 | 1 | 2017-03-02 11:32:31 | 1 | Bus |
| 3306 | 3511 | 1 | 2017-03-02 13:51:22 | 0 | NULL |
| 3307 | 3512 | 1 | 2017-03-02 14:02:28 | 0 | NULL |
| 3308 | 3584 | 1 | 2017-03-03 10:31:49 | 1 | Metro |
| 3309 | 3586 | 1 | 2017-03-03 10:32:03 | 1 | Metro |
| 3310 | 3583 | 1 | 2017-03-03 10:32:12 | 1 | Metro |
| 3311 | 3585 | 1 | 2017-03-03 10:32:17 | 1 | Metro |
| 3312 | 3556 | 2 | 2017-03-03 15:44:30 | 1 | Metro |
| 3313 | 3591 | 1 | 2017-03-04 10:15:19 | 1 | Walk |
| 3314 | 3591 | 2 | 2017-03-04 13:26:51 | 0 | NULL |
| 3315 | 3526 | 1 | 2017-03-05 09:08:12 | 1 | Metro |
| 3316 | 3527 | 1 | 2017-03-05 09:08:19 | 1 | Metro |
| 3317 | 3525 | 1 | 2017-03-05 09:08:46 | 1 | Metro |
| 3318 | 3528 | 1 | 2017-03-05 09:08:48 | 1 | Metro |
| 3319 | 3592 | 1 | 2017-03-05 10:50:16 | 1 | Taxi |
| 3320 | 3593 | 1 | 2017-03-05 10:50:48 | 1 | Taxi |
| 3321 | 3588 | 1 | 2017-03-05 10:52:03 | 1 | Metro |
| 3322 | 3589 | 1 | 2017-03-05 10:52:26 | 1 | Metro |
| 3323 | 3587 | 1 | 2017-03-05 10:52:35 | 1 | Metro |
| 3324 | 3592 | 1 | 2017-03-05 12:58:10 | 0 | NULL |
| 3325 | 3593 | 1 | 2017-03-05 14:30:09 | 0 | NULL |
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;