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,026–8,050 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 8026 | 8230 | 1 | 2019-05-21 11:21:13 | 1 | Bus |
| 8027 | 8229 | 1 | 2019-05-21 11:21:19 | 1 | Bus |
| 8028 | 8228 | 1 | 2019-05-21 11:21:47 | 1 | Bus |
| 8029 | 8244 | 2 | 2019-05-21 11:38:52 | 1 | Walk |
| 8030 | 8160 | 1 | 2019-05-21 12:15:01 | 1 | Walk |
| 8031 | 8159 | 1 | 2019-05-21 12:15:13 | 1 | Walk |
| 8032 | 8222 | 2 | 2019-05-21 16:09:50 | 1 | Private Vehicle |
| 8033 | 8221 | 2 | 2019-05-21 16:09:58 | 1 | Private Vehicle |
| 8034 | 8264 | 1 | 2019-05-22 09:24:53 | 1 | Taxi |
| 8035 | 8265 | 1 | 2019-05-22 09:25:05 | 1 | Taxi |
| 8036 | 8263 | 1 | 2019-05-22 09:25:42 | 1 | Taxi |
| 8037 | 8267 | 1 | 2019-05-24 12:41:55 | 1 | Taxi |
| 8038 | 8268 | 1 | 2019-05-24 12:42:02 | 1 | Taxi |
| 8039 | 8270 | 1 | 2019-05-24 12:42:07 | 1 | Taxi |
| 8040 | 8269 | 1 | 2019-05-24 12:42:15 | 1 | Taxi |
| 8041 | 8046 | 4 | 2019-05-24 13:15:39 | 1 | Walk |
| 8042 | 8047 | 4 | 2019-05-24 13:15:50 | 1 | Walk |
| 8043 | 8272 | 2 | 2019-05-24 15:35:14 | 1 | Taxi |
| 8044 | 8271 | 2 | 2019-05-24 15:35:32 | 1 | Taxi |
| 8045 | 8163 | 1 | 2019-05-24 16:24:51 | 1 | Walk |
| 8046 | 8177 | 1 | 2019-05-25 10:23:19 | 1 | Walk |
| 8047 | 8178 | 1 | 2019-05-25 10:23:31 | 1 | Walk |
| 8048 | 8260 | 1 | 2019-05-26 12:31:18 | 1 | Bus |
| 8049 | 8262 | 1 | 2019-05-26 12:31:24 | 1 | Bus |
| 8050 | 8261 | 1 | 2019-05-26 12:31:41 | 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;