Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 6,826–6,850 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 6826 | 7049 | 2 | 2018-11-18 11:06:30 | 1 | Walk |
| 6827 | 7051 | 2 | 2018-11-18 11:06:42 | 1 | Walk |
| 6828 | 7048 | 2 | 2018-11-18 11:06:52 | 1 | Walk |
| 6829 | 7073 | 1 | 2018-11-19 10:13:02 | 1 | Metro |
| 6830 | 7074 | 1 | 2018-11-19 10:13:11 | 1 | Metro |
| 6831 | 7075 | 1 | 2018-11-19 10:13:21 | 1 | Metro |
| 6832 | 6905 | 2 | 2018-11-19 12:18:52 | 1 | Bus |
| 6833 | 6902 | 2 | 2018-11-19 12:18:54 | 1 | Bus |
| 6834 | 6904 | 2 | 2018-11-19 12:19:02 | 1 | Bus |
| 6835 | 6903 | 2 | 2018-11-19 12:19:25 | 1 | Bus |
| 6836 | 7071 | 1 | 2018-11-19 13:54:12 | 1 | Bus |
| 6837 | 7078 | 2 | 2018-11-19 14:51:59 | 1 | Walk |
| 6838 | 7079 | 2 | 2018-11-19 14:52:12 | 1 | Walk |
| 6839 | 7077 | 2 | 2018-11-19 14:52:21 | 1 | Walk |
| 6840 | 7076 | 2 | 2018-11-19 14:52:33 | 1 | Walk |
| 6841 | 7081 | 1 | 2018-11-21 13:08:06 | 1 | Metro |
| 6842 | 7082 | 1 | 2018-11-21 13:08:36 | 1 | Metro |
| 6843 | 7011 | 1 | 2018-11-21 14:07:57 | 1 | Walk |
| 6844 | 7012 | 1 | 2018-11-21 14:08:05 | 1 | Walk |
| 6845 | 7013 | 1 | 2018-11-21 14:08:28 | 1 | Walk |
| 6846 | 7084 | 5 | 2018-11-21 14:48:13 | 1 | Bus |
| 6847 | 7004 | 2 | 2018-11-21 15:52:05 | 1 | Bus |
| 6848 | 7150 | 2 | 2018-11-22 10:59:23 | 1 | Metro |
| 6849 | 7151 | 2 | 2018-11-22 10:59:24 | 1 | Metro |
| 6850 | 7152 | 2 | 2018-11-22 10:59:26 | 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;