Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 9,501–9,525 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 9501 | 9613 | 4 | 2020-01-01 10:00:20 | 1 | Taxi |
| 9502 | 9610 | 4 | 2020-01-01 10:00:29 | 1 | Taxi |
| 9503 | 9629 | 3 | 2020-01-01 11:21:47 | 1 | Walk |
| 9504 | 9628 | 3 | 2020-01-01 11:21:53 | 1 | Walk |
| 9505 | 9591 | 4 | 2020-01-01 13:52:13 | 1 | Walk |
| 9506 | 9592 | 4 | 2020-01-01 13:52:23 | 1 | Walk |
| 9507 | 9631 | 1 | 2020-01-02 14:21:20 | 1 | Metro |
| 9508 | 9630 | 1 | 2020-01-02 14:21:38 | 1 | Metro |
| 9509 | 9619 | 4 | 2020-01-04 09:27:29 | 1 | Walk |
| 9510 | 9618 | 4 | 2020-01-04 09:27:58 | 1 | Walk |
| 9511 | 9602 | 2 | 2020-01-04 10:11:45 | 1 | Metro |
| 9512 | 9603 | 2 | 2020-01-04 10:12:07 | 1 | Metro |
| 9513 | 9601 | 2 | 2020-01-04 10:12:13 | 1 | Metro |
| 9514 | 9604 | 2 | 2020-01-04 10:12:28 | 1 | Metro |
| 9515 | 9642 | 2 | 2020-01-05 13:26:10 | 1 | Metro |
| 9516 | 9641 | 2 | 2020-01-05 13:26:52 | 1 | Metro |
| 9517 | 9640 | 1 | 2020-01-05 14:51:05 | 1 | Train |
| 9518 | 9643 | 1 | 2020-01-06 09:38:15 | 1 | Walk |
| 9519 | 9638 | 3 | 2020-01-06 11:55:43 | 1 | Metro |
| 9520 | 9639 | 3 | 2020-01-06 11:55:50 | 1 | Metro |
| 9521 | 9632 | 1 | 2020-01-06 14:52:56 | 1 | Walk |
| 9522 | 9633 | 1 | 2020-01-06 14:53:05 | 1 | Walk |
| 9523 | 9646 | 2 | 2020-01-07 10:26:28 | 1 | Metro |
| 9524 | 9615 | 4 | 2020-01-07 10:34:00 | 1 | Walk |
| 9525 | 9616 | 4 | 2020-01-07 10:34:15 | 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;