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,151–1,175 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 1151 | 1097 | 4 | 2015-10-13 13:18:53 | 1 | Bus |
| 1152 | 1100 | 4 | 2015-10-13 13:18:56 | 1 | Bus |
| 1153 | 1098 | 4 | 2015-10-13 13:19:00 | 1 | Bus |
| 1154 | 1105 | 4 | 2015-10-13 13:19:07 | 1 | Bus |
| 1155 | 1101 | 4 | 2015-10-13 13:19:11 | 1 | Bus |
| 1156 | 1107 | 4 | 2015-10-13 13:19:15 | 1 | Bus |
| 1157 | 1096 | 4 | 2015-10-13 13:19:26 | 1 | Bus |
| 1158 | 1106 | 4 | 2015-10-13 13:19:41 | 1 | Bus |
| 1159 | 1099 | 4 | 2015-10-13 13:19:55 | 1 | Bus |
| 1160 | 1109 | 4 | 2015-10-13 13:20:17 | 1 | Bus |
| 1161 | 1104 | 4 | 2015-10-13 13:20:21 | 1 | Bus |
| 1162 | 1102 | 4 | 2015-10-13 13:20:23 | 1 | Bus |
| 1163 | 1108 | 4 | 2015-10-13 13:20:27 | 1 | Bus |
| 1164 | 1112 | 4 | 2015-10-13 13:20:38 | 1 | Bus |
| 1165 | 1110 | 4 | 2015-10-13 13:20:43 | 1 | Bus |
| 1166 | 1118 | 4 | 2015-10-13 13:20:53 | 1 | Bus |
| 1167 | 1124 | 4 | 2015-10-13 13:20:56 | 1 | Bus |
| 1168 | 1119 | 4 | 2015-10-13 13:20:59 | 1 | Bus |
| 1169 | 1103 | 4 | 2015-10-13 13:21:11 | 1 | Bus |
| 1170 | 1121 | 4 | 2015-10-13 13:21:11 | 1 | Bus |
| 1171 | 1114 | 4 | 2015-10-13 13:21:15 | 1 | Bus |
| 1172 | 1122 | 4 | 2015-10-13 13:21:17 | 1 | Bus |
| 1173 | 1113 | 4 | 2015-10-13 13:21:29 | 1 | Bus |
| 1174 | 1117 | 4 | 2015-10-13 13:21:39 | 1 | Bus |
| 1175 | 1111 | 4 | 2015-10-13 13:21:51 | 1 | Bus |
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;