Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 1,026–1,050 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 1026 | 1034 | 1 | 2015-09-09 10:25:25 | 1 | Walk |
| 1027 | 1035 | 1 | 2015-09-09 10:25:48 | 1 | Walk |
| 1028 | 1034 | 1 | 2015-09-09 12:43:43 | 0 | NULL |
| 1029 | 1035 | 1 | 2015-09-09 12:51:54 | 0 | NULL |
| 1030 | 1074 | 3 | 2015-09-09 16:57:18 | 1 | Metro |
| 1031 | 1075 | 3 | 2015-09-09 16:57:27 | 1 | Metro |
| 1032 | 1080 | 3 | 2015-09-11 09:19:31 | 1 | Train |
| 1033 | 1084 | 5 | 2015-09-11 12:20:09 | 1 | Walk |
| 1034 | 1083 | 5 | 2015-09-11 12:20:14 | 1 | Walk |
| 1035 | 1085 | 5 | 2015-09-11 12:20:25 | 1 | Walk |
| 1036 | 1086 | 3 | 2015-09-12 15:42:43 | 1 | Metro |
| 1037 | 1087 | 1 | 2015-09-13 10:31:19 | 1 | Metro |
| 1038 | 1088 | 1 | 2015-09-13 10:31:39 | 1 | Metro |
| 1039 | 1090 | 1 | 2015-09-13 11:24:11 | 1 | Walk |
| 1040 | 1089 | 1 | 2015-09-13 11:24:28 | 1 | Walk |
| 1041 | 1076 | 1 | 2015-09-14 15:08:18 | 1 | Taxi |
| 1042 | 1079 | 1 | 2015-09-14 15:08:19 | 1 | Taxi |
| 1043 | 1077 | 1 | 2015-09-14 15:08:22 | 1 | Taxi |
| 1044 | 1078 | 1 | 2015-09-14 15:08:50 | 1 | Taxi |
| 1045 | 1077 | 1 | 2015-09-14 17:23:26 | 0 | NULL |
| 1046 | 1076 | 2 | 2015-09-14 17:28:22 | 0 | NULL |
| 1047 | 1132 | 1 | 2015-09-16 11:38:47 | 1 | Metro |
| 1048 | 1133 | 1 | 2015-09-16 11:39:08 | 1 | Metro |
| 1049 | 961 | 1 | 2015-09-16 16:01:44 | 1 | Walk |
| 1050 | 958 | 1 | 2015-09-16 16:01:53 | 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;