Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 5,826–5,850 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 5826 | 6068 | 1 | 2018-07-05 12:25:33 | 1 | Other |
| 5827 | 6182 | 3 | 2018-07-05 12:55:16 | 1 | Walk |
| 5828 | 6171 | 2 | 2018-07-06 14:15:56 | 1 | Metro |
| 5829 | 6188 | 1 | 2018-07-07 09:00:17 | 1 | Taxi |
| 5830 | 6187 | 1 | 2018-07-07 09:00:38 | 1 | Taxi |
| 5831 | 6189 | 1 | 2018-07-07 09:00:54 | 1 | Taxi |
| 5832 | 6186 | 1 | 2018-07-07 09:00:55 | 1 | Taxi |
| 5833 | 6095 | 1 | 2018-07-07 10:27:04 | 1 | Walk |
| 5834 | 6093 | 1 | 2018-07-07 10:27:36 | 1 | Walk |
| 5835 | 6094 | 1 | 2018-07-07 10:27:37 | 1 | Walk |
| 5836 | 5941 | 1 | 2018-07-07 10:32:32 | 1 | Metro |
| 5837 | 5940 | 1 | 2018-07-07 10:32:45 | 1 | Metro |
| 5838 | 6191 | 1 | 2018-07-08 10:26:36 | 1 | Bus |
| 5839 | 6190 | 1 | 2018-07-08 10:26:43 | 1 | Bus |
| 5840 | 6051 | 3 | 2018-07-08 10:43:58 | 1 | Walk |
| 5841 | 6050 | 3 | 2018-07-08 10:44:14 | 1 | Walk |
| 5842 | 6194 | 1 | 2018-07-09 13:59:52 | 1 | Metro |
| 5843 | 6195 | 1 | 2018-07-09 14:00:24 | 1 | Metro |
| 5844 | 6092 | 3 | 2018-07-09 15:54:02 | 1 | Metro |
| 5845 | 6091 | 3 | 2018-07-09 15:54:15 | 1 | Metro |
| 5846 | 6090 | 3 | 2018-07-09 15:54:18 | 1 | Metro |
| 5847 | 6100 | 3 | 2018-07-10 09:36:50 | 1 | Metro |
| 5848 | 6196 | 1 | 2018-07-10 10:45:05 | 1 | Walk |
| 5849 | 6175 | 3 | 2018-07-10 11:01:43 | 1 | Walk |
| 5850 | 6174 | 3 | 2018-07-10 11:01:44 | 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;