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,226–8,250 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 8226 | 8404 | 4 | 2019-06-22 09:53:58 | 1 | Walk |
| 8227 | 8406 | 4 | 2019-06-22 09:54:20 | 1 | Walk |
| 8228 | 8418 | 2 | 2019-06-22 09:55:07 | 1 | Metro |
| 8229 | 8416 | 2 | 2019-06-22 09:55:11 | 1 | Metro |
| 8230 | 8417 | 2 | 2019-06-22 09:55:25 | 1 | Metro |
| 8231 | 8419 | 2 | 2019-06-22 09:55:31 | 1 | Metro |
| 8232 | 8396 | 1 | 2019-06-22 10:13:45 | 1 | Metro |
| 8233 | 8365 | 1 | 2019-06-22 11:05:28 | 1 | Metro |
| 8234 | 8366 | 1 | 2019-06-22 11:05:52 | 1 | Metro |
| 8235 | 8401 | 1 | 2019-06-22 11:46:00 | 1 | Metro |
| 8236 | 8400 | 1 | 2019-06-22 11:46:08 | 1 | Metro |
| 8237 | 8402 | 1 | 2019-06-22 11:46:08 | 1 | Metro |
| 8238 | 8403 | 1 | 2019-06-22 11:46:09 | 1 | Metro |
| 8239 | 8358 | 5 | 2019-06-22 12:08:14 | 1 | Walk |
| 8240 | 8359 | 5 | 2019-06-22 12:08:18 | 1 | Walk |
| 8241 | 8354 | 1 | 2019-06-22 12:22:55 | 1 | Other |
| 8242 | 8353 | 1 | 2019-06-22 12:22:57 | 1 | Other |
| 8243 | 8289 | 4 | 2019-06-23 16:50:37 | 1 | Walk |
| 8244 | 8291 | 4 | 2019-06-23 16:50:51 | 1 | Walk |
| 8245 | 8290 | 4 | 2019-06-23 16:50:53 | 1 | Walk |
| 8246 | 8367 | 2 | 2019-06-24 10:34:58 | 1 | Metro |
| 8247 | 8368 | 2 | 2019-06-24 10:35:11 | 1 | Metro |
| 8248 | 8390 | 3 | 2019-06-24 12:47:01 | 1 | Walk |
| 8249 | 8388 | 3 | 2019-06-24 12:47:30 | 1 | Walk |
| 8250 | 8389 | 3 | 2019-06-24 12:47:36 | 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;