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,901–2,925 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 2901 | 3014 | 2 | 2016-11-11 14:38:39 | 1 | Walk |
| 2902 | 3017 | 4 | 2016-11-12 10:03:54 | 1 | Metro |
| 2903 | 3018 | 4 | 2016-11-12 10:04:41 | 1 | Metro |
| 2904 | 3010 | 2 | 2016-11-12 10:29:13 | 1 | Walk |
| 2905 | 3009 | 2 | 2016-11-12 10:29:16 | 1 | Walk |
| 2906 | 3010 | 2 | 2016-11-12 12:10:11 | 0 | NULL |
| 2907 | 3009 | 2 | 2016-11-12 13:12:42 | 0 | NULL |
| 2908 | 2993 | 4 | 2016-11-13 10:31:17 | 1 | Metro |
| 2909 | 2994 | 4 | 2016-11-13 10:31:32 | 1 | Metro |
| 2910 | 3019 | 2 | 2016-11-13 12:32:31 | 1 | Walk |
| 2911 | 3022 | 1 | 2016-11-14 10:50:15 | 1 | Metro |
| 2912 | 3020 | 1 | 2016-11-14 10:50:16 | 1 | Metro |
| 2913 | 3021 | 1 | 2016-11-14 10:50:30 | 1 | Metro |
| 2914 | 2998 | 1 | 2016-11-14 12:01:26 | 1 | Walk |
| 2915 | 2999 | 1 | 2016-11-14 12:01:27 | 1 | Walk |
| 2916 | 3024 | 4 | 2016-11-15 15:56:28 | 1 | Walk |
| 2917 | 3023 | 4 | 2016-11-15 15:56:53 | 1 | Walk |
| 2918 | 3025 | 5 | 2016-11-17 11:05:29 | 1 | Walk |
| 2919 | 3026 | 5 | 2016-11-17 11:05:37 | 1 | Walk |
| 2920 | 3027 | 5 | 2016-11-17 11:05:59 | 1 | Walk |
| 2921 | 3011 | 1 | 2016-11-17 11:12:21 | 1 | Metro |
| 2922 | 3032 | 1 | 2016-11-20 09:56:42 | 1 | Metro |
| 2923 | 3033 | 1 | 2016-11-20 09:57:11 | 1 | Metro |
| 2924 | 3031 | 1 | 2016-11-20 09:57:20 | 1 | Metro |
| 2925 | 3034 | 1 | 2016-11-20 09:57:21 | 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;