Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 8,626–8,650 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 8626 | 8761 | 1 | 2019-08-21 10:04:37 | 1 | Walk |
| 8627 | 8759 | 1 | 2019-08-21 10:54:56 | 1 | Train |
| 8628 | 8776 | 4 | 2019-08-21 11:28:45 | 1 | Private Vehicle |
| 8629 | 8794 | 1 | 2019-08-22 14:41:05 | 1 | Walk |
| 8630 | 8793 | 1 | 2019-08-22 14:41:39 | 1 | Walk |
| 8631 | 8778 | 4 | 2019-08-22 16:40:51 | 1 | Train |
| 8632 | 8798 | 1 | 2019-08-23 10:16:21 | 1 | Walk |
| 8633 | 8797 | 2 | 2019-08-23 13:35:27 | 1 | Private Vehicle |
| 8634 | 8807 | 1 | 2019-08-24 09:47:33 | 1 | Other |
| 8635 | 8805 | 1 | 2019-08-24 09:47:35 | 1 | Other |
| 8636 | 8806 | 1 | 2019-08-24 09:48:01 | 1 | Other |
| 8637 | 8792 | 2 | 2019-08-24 14:47:24 | 1 | Train |
| 8638 | 8781 | 3 | 2019-08-24 15:19:05 | 1 | Train |
| 8639 | 8782 | 3 | 2019-08-24 15:19:07 | 1 | Train |
| 8640 | 8763 | 4 | 2019-08-25 10:38:06 | 1 | Metro |
| 8641 | 8764 | 4 | 2019-08-25 10:38:13 | 1 | Metro |
| 8642 | 8766 | 4 | 2019-08-25 10:38:18 | 1 | Metro |
| 8643 | 8762 | 4 | 2019-08-25 10:38:32 | 1 | Metro |
| 8644 | 8765 | 4 | 2019-08-25 10:38:36 | 1 | Metro |
| 8645 | 8691 | 1 | 2019-08-25 13:07:49 | 1 | Metro |
| 8646 | 8692 | 1 | 2019-08-25 13:08:06 | 1 | Metro |
| 8647 | 8820 | 1 | 2019-08-25 14:22:33 | 1 | Walk |
| 8648 | 8821 | 1 | 2019-08-25 14:22:50 | 1 | Walk |
| 8649 | 8786 | 1 | 2019-08-25 14:27:44 | 1 | Metro |
| 8650 | 8787 | 1 | 2019-08-25 14:28:15 | 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;