Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 5,051–5,075 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 5051 | 5246 | 4 | 2018-02-04 10:58:03 | 1 | Bus |
| 5052 | 5241 | 5 | 2018-02-05 10:34:11 | 1 | Taxi |
| 5053 | 5249 | 3 | 2018-02-06 09:51:14 | 1 | Bus |
| 5054 | 5248 | 3 | 2018-02-06 09:51:15 | 1 | Bus |
| 5055 | 5247 | 5 | 2018-02-07 11:07:51 | 1 | Walk |
| 5056 | 5256 | 1 | 2018-02-08 09:21:36 | 1 | Walk |
| 5057 | 5255 | 1 | 2018-02-08 09:22:03 | 1 | Walk |
| 5058 | 5216 | 4 | 2018-02-08 11:07:08 | 1 | Other |
| 5059 | 5212 | 3 | 2018-02-08 12:40:40 | 1 | Walk |
| 5060 | 5213 | 3 | 2018-02-08 12:41:02 | 1 | Walk |
| 5061 | 5258 | 2 | 2018-02-08 13:38:32 | 1 | Metro |
| 5062 | 5257 | 2 | 2018-02-08 13:38:52 | 1 | Metro |
| 5063 | 5253 | 2 | 2018-02-09 11:58:15 | 1 | Bus |
| 5064 | 5254 | 2 | 2018-02-09 11:58:17 | 1 | Bus |
| 5065 | 5252 | 1 | 2018-02-09 13:16:31 | 1 | Metro |
| 5066 | 5267 | 3 | 2018-02-11 12:56:30 | 1 | Bus |
| 5067 | 4960 | 1 | 2018-02-11 14:24:11 | 1 | Walk |
| 5068 | 4959 | 1 | 2018-02-11 14:24:21 | 1 | Walk |
| 5069 | 4958 | 1 | 2018-02-11 14:24:23 | 1 | Walk |
| 5070 | 4956 | 1 | 2018-02-11 14:24:24 | 1 | Walk |
| 5071 | 4957 | 1 | 2018-02-11 14:24:26 | 1 | Walk |
| 5072 | 5222 | 5 | 2018-02-13 10:15:38 | 1 | Walk |
| 5073 | 5223 | 5 | 2018-02-13 10:15:51 | 1 | Walk |
| 5074 | 5225 | 5 | 2018-02-13 10:15:54 | 1 | Walk |
| 5075 | 5224 | 5 | 2018-02-13 10:15:55 | 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;