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,326–7,350 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 7326 | 7431 | 1 | 2019-02-19 09:37:55 | 1 | Bus |
| 7327 | 7426 | 1 | 2019-02-19 09:38:07 | 1 | Bus |
| 7328 | 7405 | 1 | 2019-02-19 09:38:09 | 1 | Bus |
| 7329 | 7430 | 1 | 2019-02-19 09:38:31 | 1 | Bus |
| 7330 | 7407 | 1 | 2019-02-19 09:38:37 | 1 | Bus |
| 7331 | 7425 | 1 | 2019-02-19 09:38:37 | 1 | Bus |
| 7332 | 7442 | 1 | 2019-02-19 09:38:50 | 1 | Bus |
| 7333 | 7412 | 1 | 2019-02-19 09:39:01 | 1 | Bus |
| 7334 | 7416 | 1 | 2019-02-19 09:39:22 | 1 | Bus |
| 7335 | 7432 | 1 | 2019-02-19 09:39:26 | 1 | Bus |
| 7336 | 7436 | 1 | 2019-02-19 09:39:54 | 1 | Bus |
| 7337 | 7413 | 1 | 2019-02-19 09:40:01 | 1 | Bus |
| 7338 | 7437 | 1 | 2019-02-19 09:40:01 | 1 | Bus |
| 7339 | 7420 | 1 | 2019-02-19 09:40:06 | 1 | Bus |
| 7340 | 7433 | 1 | 2019-02-19 09:40:17 | 1 | Bus |
| 7341 | 7417 | 1 | 2019-02-19 09:40:29 | 1 | Bus |
| 7342 | 7421 | 1 | 2019-02-19 09:40:49 | 1 | Bus |
| 7343 | 7419 | 1 | 2019-02-19 09:40:55 | 1 | Bus |
| 7344 | 7422 | 1 | 2019-02-19 09:41:01 | 1 | Bus |
| 7345 | 7429 | 1 | 2019-02-19 09:41:05 | 1 | Bus |
| 7346 | 7440 | 1 | 2019-02-19 09:42:04 | 1 | Bus |
| 7347 | 7441 | 1 | 2019-02-19 09:42:13 | 1 | Bus |
| 7348 | 7439 | 1 | 2019-02-19 09:42:45 | 1 | Bus |
| 7349 | 7427 | 1 | 2019-02-19 09:43:55 | 1 | Bus |
| 7350 | 7434 | 1 | 2019-02-19 09:44:55 | 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;