Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 2,851–2,875 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 2851 | 2715 | 4 | 2016-10-28 11:14:49 | 1 | Bus |
| 2852 | 2726 | 4 | 2016-10-28 11:14:52 | 1 | Bus |
| 2853 | 2724 | 4 | 2016-10-28 11:15:05 | 1 | Bus |
| 2854 | 2722 | 4 | 2016-10-28 11:15:39 | 1 | Bus |
| 2855 | 2730 | 4 | 2016-10-28 11:15:53 | 1 | Bus |
| 2856 | 2723 | 4 | 2016-10-28 11:16:15 | 1 | Bus |
| 2857 | 2727 | 4 | 2016-10-28 11:16:29 | 1 | Bus |
| 2858 | 2716 | 4 | 2016-10-28 11:16:44 | 1 | Bus |
| 2859 | 2729 | 4 | 2016-10-28 11:16:49 | 1 | Bus |
| 2860 | 2941 | 2 | 2016-10-28 15:11:06 | 1 | Taxi |
| 2861 | 2921 | 5 | 2016-10-29 09:34:49 | 1 | Walk |
| 2862 | 2920 | 5 | 2016-10-29 09:35:11 | 1 | Walk |
| 2863 | 2861 | 2 | 2016-10-29 11:16:37 | 1 | Train |
| 2864 | 2860 | 2 | 2016-10-29 11:16:40 | 1 | Train |
| 2865 | 2859 | 2 | 2016-10-29 11:17:15 | 1 | Train |
| 2866 | 2858 | 2 | 2016-10-29 11:17:20 | 1 | Train |
| 2867 | 2916 | 3 | 2016-10-30 12:09:26 | 1 | Metro |
| 2868 | 2915 | 3 | 2016-10-30 12:09:48 | 1 | Metro |
| 2869 | 2916 | 1 | 2016-10-30 15:14:09 | 0 | NULL |
| 2870 | 2943 | 1 | 2016-10-30 15:24:36 | 1 | Walk |
| 2871 | 2942 | 1 | 2016-10-30 15:24:45 | 1 | Walk |
| 2872 | 2915 | 3 | 2016-10-30 15:55:11 | 0 | NULL |
| 2873 | 2865 | 5 | 2016-10-30 15:58:51 | 1 | Metro |
| 2874 | 2950 | 3 | 2016-11-02 09:14:21 | 1 | Walk |
| 2875 | 2951 | 3 | 2016-11-02 09:14:49 | 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;