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,126–9,150 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 9126 | 9197 | 4 | 2019-11-09 11:32:31 | 1 | Bus |
| 9127 | 9206 | 4 | 2019-11-09 11:32:51 | 1 | Bus |
| 9128 | 9220 | 4 | 2019-11-09 11:32:55 | 1 | Bus |
| 9129 | 9215 | 4 | 2019-11-09 11:33:01 | 1 | Bus |
| 9130 | 9212 | 4 | 2019-11-09 11:33:11 | 1 | Bus |
| 9131 | 9200 | 4 | 2019-11-09 11:33:39 | 1 | Bus |
| 9132 | 9323 | 1 | 2019-11-09 11:33:42 | 1 | Walk |
| 9133 | 9202 | 4 | 2019-11-09 11:33:49 | 1 | Bus |
| 9134 | 9324 | 1 | 2019-11-09 11:33:49 | 1 | Walk |
| 9135 | 9204 | 4 | 2019-11-09 11:33:55 | 1 | Bus |
| 9136 | 9210 | 4 | 2019-11-09 11:34:41 | 1 | Bus |
| 9137 | 9209 | 4 | 2019-11-09 11:34:55 | 1 | Bus |
| 9138 | 9205 | 4 | 2019-11-09 11:35:10 | 1 | Bus |
| 9139 | 9213 | 4 | 2019-11-09 11:35:14 | 1 | Bus |
| 9140 | 9211 | 4 | 2019-11-09 11:36:13 | 1 | Bus |
| 9141 | 9219 | 4 | 2019-11-09 11:36:20 | 1 | Bus |
| 9142 | 9214 | 4 | 2019-11-09 11:36:25 | 1 | Bus |
| 9143 | 9221 | 4 | 2019-11-09 11:36:42 | 1 | Bus |
| 9144 | 9225 | 4 | 2019-11-09 11:36:45 | 1 | Bus |
| 9145 | 9216 | 4 | 2019-11-09 11:36:51 | 1 | Bus |
| 9146 | 9226 | 4 | 2019-11-09 11:36:55 | 1 | Bus |
| 9147 | 9224 | 4 | 2019-11-09 11:37:15 | 1 | Bus |
| 9148 | 9217 | 4 | 2019-11-09 11:37:37 | 1 | Bus |
| 9149 | 9218 | 4 | 2019-11-09 11:38:25 | 1 | Bus |
| 9150 | 9222 | 4 | 2019-11-09 11:38:47 | 1 | Bus |
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;