Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 8,851–8,875 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 8851 | 8850 | 1 | 2019-10-07 10:19:03 | 1 | Other |
| 8852 | 9150 | 5 | 2019-10-08 11:07:57 | 1 | Walk |
| 8853 | 9149 | 5 | 2019-10-08 11:07:59 | 1 | Walk |
| 8854 | 9151 | 5 | 2019-10-08 11:08:02 | 1 | Walk |
| 8855 | 9147 | 5 | 2019-10-08 11:08:27 | 1 | Walk |
| 8856 | 9148 | 5 | 2019-10-08 11:08:36 | 1 | Walk |
| 8857 | 9162 | 2 | 2019-10-09 09:41:51 | 1 | Metro |
| 8858 | 9162 | 2 | 2019-10-09 12:03:37 | 0 | NULL |
| 8859 | 9166 | 3 | 2019-10-11 10:35:54 | 1 | Bus |
| 8860 | 9167 | 3 | 2019-10-11 10:36:03 | 1 | Bus |
| 8861 | 9127 | 3 | 2019-10-11 14:27:49 | 1 | Walk |
| 8862 | 9126 | 3 | 2019-10-11 14:27:56 | 1 | Walk |
| 8863 | 9164 | 1 | 2019-10-12 11:59:49 | 1 | Taxi |
| 8864 | 9165 | 1 | 2019-10-12 12:00:07 | 1 | Taxi |
| 8865 | 9160 | 1 | 2019-10-13 10:40:54 | 1 | Walk |
| 8866 | 9161 | 1 | 2019-10-13 10:41:15 | 1 | Walk |
| 8867 | 9137 | 3 | 2019-10-13 14:59:08 | 1 | Bus |
| 8868 | 9136 | 3 | 2019-10-13 14:59:17 | 1 | Bus |
| 8869 | 9135 | 3 | 2019-10-13 14:59:23 | 1 | Bus |
| 8870 | 9114 | 3 | 2019-10-14 10:36:17 | 1 | Metro |
| 8871 | 9113 | 3 | 2019-10-14 10:36:25 | 1 | Metro |
| 8872 | 9171 | 2 | 2019-10-14 11:25:51 | 1 | Taxi |
| 8873 | 9145 | 4 | 2019-10-14 13:39:07 | 1 | Walk |
| 8874 | 9146 | 4 | 2019-10-14 13:39:32 | 1 | Walk |
| 8875 | 9174 | 4 | 2019-10-14 14:14:59 | 1 | Taxi |
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;