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,676–7,700 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 7676 | 7647 | 1 | 2019-04-05 11:04:37 | 1 | Walk |
| 7677 | 7650 | 1 | 2019-04-05 11:04:37 | 1 | Walk |
| 7678 | 7646 | 1 | 2019-04-05 11:04:38 | 1 | Walk |
| 7679 | 7648 | 1 | 2019-04-05 11:04:53 | 1 | Walk |
| 7680 | 7986 | 1 | 2019-04-06 09:13:49 | 1 | Bus |
| 7681 | 7987 | 1 | 2019-04-06 09:13:54 | 1 | Bus |
| 7682 | 7988 | 1 | 2019-04-06 09:42:42 | 1 | Metro |
| 7683 | 7989 | 1 | 2019-04-06 09:57:11 | 1 | Metro |
| 7684 | 7990 | 2 | 2019-04-07 09:59:28 | 1 | Walk |
| 7685 | 7991 | 2 | 2019-04-07 09:59:29 | 1 | Walk |
| 7686 | 7978 | 4 | 2019-04-07 11:14:48 | 1 | Walk |
| 7687 | 7994 | 1 | 2019-04-08 09:38:48 | 1 | Metro |
| 7688 | 7995 | 1 | 2019-04-08 11:57:52 | 1 | Metro |
| 7689 | 7996 | 1 | 2019-04-08 11:57:52 | 1 | Metro |
| 7690 | 8035 | 1 | 2019-04-08 12:02:14 | 1 | Metro |
| 7691 | 8036 | 1 | 2019-04-08 12:02:26 | 1 | Metro |
| 7692 | 8038 | 2 | 2019-04-09 12:10:32 | 1 | Private Vehicle |
| 7693 | 8039 | 2 | 2019-04-09 12:10:55 | 1 | Private Vehicle |
| 7694 | 8040 | 2 | 2019-04-09 12:11:09 | 1 | Private Vehicle |
| 7695 | 8042 | 1 | 2019-04-09 15:44:10 | 1 | Taxi |
| 7696 | 8041 | 1 | 2019-04-09 15:44:18 | 1 | Taxi |
| 7697 | 7616 | 4 | 2019-04-10 14:10:11 | 1 | Metro |
| 7698 | 8045 | 1 | 2019-04-11 10:24:49 | 1 | Walk |
| 7699 | 7975 | 2 | 2019-04-11 11:54:59 | 1 | Metro |
| 7700 | 7976 | 2 | 2019-04-11 11:55:02 | 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;