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,926–7,950 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 7926 | 8088 | 1 | 2019-05-04 15:26:44 | 1 | Metro |
| 7927 | 8143 | 1 | 2019-05-05 13:52:53 | 1 | Walk |
| 7928 | 8166 | 5 | 2019-05-05 15:58:02 | 1 | Bus |
| 7929 | 8164 | 5 | 2019-05-05 15:58:05 | 1 | Bus |
| 7930 | 8167 | 5 | 2019-05-05 15:58:14 | 1 | Bus |
| 7931 | 8165 | 5 | 2019-05-05 15:58:19 | 1 | Bus |
| 7932 | 8134 | 4 | 2019-05-06 12:48:53 | 1 | Walk |
| 7933 | 8135 | 4 | 2019-05-06 12:48:57 | 1 | Walk |
| 7934 | 8187 | 2 | 2019-05-07 14:55:50 | 1 | Metro |
| 7935 | 8186 | 2 | 2019-05-07 14:56:17 | 1 | Metro |
| 7936 | 8199 | 3 | 2019-05-09 09:43:40 | 1 | Metro |
| 7937 | 8200 | 3 | 2019-05-09 09:44:26 | 1 | Metro |
| 7938 | 8202 | 3 | 2019-05-09 11:15:08 | 1 | Walk |
| 7939 | 8201 | 3 | 2019-05-09 11:15:46 | 1 | Walk |
| 7940 | 8182 | 3 | 2019-05-10 10:46:37 | 1 | Bus |
| 7941 | 8185 | 3 | 2019-05-10 10:46:56 | 1 | Bus |
| 7942 | 8183 | 3 | 2019-05-10 10:47:04 | 1 | Bus |
| 7943 | 8184 | 3 | 2019-05-10 10:47:06 | 1 | Bus |
| 7944 | 8122 | 4 | 2019-05-10 10:58:34 | 1 | Walk |
| 7945 | 8123 | 4 | 2019-05-10 10:58:34 | 1 | Walk |
| 7946 | 8092 | 3 | 2019-05-10 16:18:02 | 1 | Train |
| 7947 | 8091 | 3 | 2019-05-10 16:18:27 | 1 | Train |
| 7948 | 8090 | 3 | 2019-05-10 16:18:30 | 1 | Train |
| 7949 | 8205 | 3 | 2019-05-11 09:28:08 | 1 | Train |
| 7950 | 8206 | 3 | 2019-05-11 09:28:34 | 1 | Train |
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;