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,076–6,100 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 6076 | 6402 | 2 | 2018-08-06 09:59:03 | 1 | Metro |
| 6077 | 6404 | 1 | 2018-08-06 11:32:13 | 1 | Other |
| 6078 | 6403 | 1 | 2018-08-06 11:32:18 | 1 | Other |
| 6079 | 6352 | 5 | 2018-08-06 11:59:19 | 1 | Walk |
| 6080 | 6350 | 5 | 2018-08-06 11:59:20 | 1 | Walk |
| 6081 | 6353 | 5 | 2018-08-06 11:59:27 | 1 | Walk |
| 6082 | 6351 | 5 | 2018-08-06 11:59:51 | 1 | Walk |
| 6083 | 6406 | 1 | 2018-08-06 12:54:07 | 1 | Other |
| 6084 | 6405 | 1 | 2018-08-06 12:54:09 | 1 | Other |
| 6085 | 6314 | 1 | 2018-08-07 09:30:55 | 1 | Walk |
| 6086 | 6315 | 1 | 2018-08-07 09:30:58 | 1 | Walk |
| 6087 | 6312 | 1 | 2018-08-07 09:31:21 | 1 | Walk |
| 6088 | 6311 | 1 | 2018-08-07 09:31:23 | 1 | Walk |
| 6089 | 6313 | 1 | 2018-08-07 09:31:34 | 1 | Walk |
| 6090 | 6294 | 1 | 2018-08-07 10:42:17 | 1 | Walk |
| 6091 | 6295 | 1 | 2018-08-07 10:42:20 | 1 | Walk |
| 6092 | 6411 | 1 | 2018-08-07 10:43:26 | 1 | Taxi |
| 6093 | 6412 | 1 | 2018-08-07 10:43:28 | 1 | Taxi |
| 6094 | 6410 | 1 | 2018-08-07 10:43:41 | 1 | Taxi |
| 6095 | 6413 | 5 | 2018-08-07 16:31:45 | 1 | Metro |
| 6096 | 6414 | 5 | 2018-08-07 16:31:59 | 1 | Metro |
| 6097 | 6415 | 1 | 2018-08-08 11:10:14 | 1 | Bus |
| 6098 | 6424 | 1 | 2018-08-09 10:24:16 | 1 | Bus |
| 6099 | 6423 | 1 | 2018-08-09 10:24:37 | 1 | Bus |
| 6100 | 6425 | 2 | 2018-08-09 11:31:43 | 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;