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,151–5,175 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 5151 | 5312 | 1 | 2018-03-06 12:50:23 | 1 | Other |
| 5152 | 5311 | 1 | 2018-03-06 12:50:43 | 1 | Other |
| 5153 | 5310 | 1 | 2018-03-06 12:50:52 | 1 | Other |
| 5154 | 5348 | 3 | 2018-03-07 11:10:47 | 1 | Walk |
| 5155 | 5347 | 3 | 2018-03-07 11:11:07 | 1 | Walk |
| 5156 | 5349 | 4 | 2018-03-08 11:31:38 | 1 | Bus |
| 5157 | 5354 | 1 | 2018-03-09 12:32:32 | 1 | Walk |
| 5158 | 5355 | 1 | 2018-03-09 12:32:34 | 1 | Walk |
| 5159 | 5356 | 1 | 2018-03-09 12:33:02 | 1 | Walk |
| 5160 | 5353 | 1 | 2018-03-09 12:33:06 | 1 | Walk |
| 5161 | 5358 | 1 | 2018-03-10 10:45:43 | 1 | Walk |
| 5162 | 5345 | 2 | 2018-03-10 11:22:13 | 1 | Walk |
| 5163 | 5344 | 2 | 2018-03-10 11:22:18 | 1 | Walk |
| 5164 | 5346 | 2 | 2018-03-10 11:22:24 | 1 | Walk |
| 5165 | 5361 | 1 | 2018-03-11 09:30:22 | 1 | Walk |
| 5166 | 5360 | 1 | 2018-03-11 09:30:56 | 1 | Walk |
| 5167 | 5359 | 1 | 2018-03-11 10:36:35 | 1 | Walk |
| 5168 | 5362 | 1 | 2018-03-11 13:20:54 | 1 | Train |
| 5169 | 5367 | 2 | 2018-03-13 11:44:27 | 1 | Private Vehicle |
| 5170 | 5365 | 2 | 2018-03-13 11:44:49 | 1 | Private Vehicle |
| 5171 | 5366 | 2 | 2018-03-13 11:44:59 | 1 | Private Vehicle |
| 5172 | 5368 | 2 | 2018-03-13 11:45:11 | 1 | Private Vehicle |
| 5173 | 5364 | 1 | 2018-03-14 13:51:26 | 1 | Walk |
| 5174 | 5363 | 1 | 2018-03-14 13:51:47 | 1 | Walk |
| 5175 | 5373 | 4 | 2018-03-15 11:49:34 | 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;