Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 7,301–7,325 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 7301 | 7392 | 1 | 2019-02-19 09:34:49 | 1 | Bus |
| 7302 | 7393 | 1 | 2019-02-19 09:34:57 | 1 | Bus |
| 7303 | 7395 | 1 | 2019-02-19 09:35:13 | 1 | Bus |
| 7304 | 7402 | 1 | 2019-02-19 09:35:17 | 1 | Bus |
| 7305 | 7401 | 1 | 2019-02-19 09:35:25 | 1 | Bus |
| 7306 | 7394 | 1 | 2019-02-19 09:35:30 | 1 | Bus |
| 7307 | 7396 | 1 | 2019-02-19 09:35:35 | 1 | Bus |
| 7308 | 7397 | 1 | 2019-02-19 09:35:37 | 1 | Bus |
| 7309 | 7399 | 1 | 2019-02-19 09:35:45 | 1 | Bus |
| 7310 | 7410 | 1 | 2019-02-19 09:35:49 | 1 | Bus |
| 7311 | 7411 | 1 | 2019-02-19 09:35:53 | 1 | Bus |
| 7312 | 7404 | 1 | 2019-02-19 09:35:55 | 1 | Bus |
| 7313 | 7418 | 1 | 2019-02-19 09:36:21 | 1 | Bus |
| 7314 | 7398 | 1 | 2019-02-19 09:36:22 | 1 | Bus |
| 7315 | 7400 | 1 | 2019-02-19 09:36:26 | 1 | Bus |
| 7316 | 7415 | 1 | 2019-02-19 09:36:35 | 1 | Bus |
| 7317 | 7406 | 1 | 2019-02-19 09:36:41 | 1 | Bus |
| 7318 | 7424 | 1 | 2019-02-19 09:36:45 | 1 | Bus |
| 7319 | 7414 | 1 | 2019-02-19 09:36:55 | 1 | Bus |
| 7320 | 7423 | 1 | 2019-02-19 09:37:15 | 1 | Bus |
| 7321 | 7408 | 1 | 2019-02-19 09:37:16 | 1 | Bus |
| 7322 | 7403 | 1 | 2019-02-19 09:37:27 | 1 | Bus |
| 7323 | 7428 | 1 | 2019-02-19 09:37:40 | 1 | Bus |
| 7324 | 7438 | 1 | 2019-02-19 09:37:41 | 1 | Bus |
| 7325 | 7409 | 1 | 2019-02-19 09:37:45 | 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;