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,101–1,125 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 1101 | 1282 | 1 | 2015-10-02 09:16:43 | 1 | Walk |
| 1102 | 1281 | 1 | 2015-10-02 09:16:52 | 1 | Walk |
| 1103 | 1280 | 1 | 2015-10-02 09:17:20 | 1 | Walk |
| 1104 | 1284 | 1 | 2015-10-02 09:17:20 | 1 | Walk |
| 1105 | 1279 | 1 | 2015-10-02 09:25:40 | 1 | Other |
| 1106 | 1285 | 1 | 2015-10-02 12:59:29 | 1 | Walk |
| 1107 | 1286 | 2 | 2015-10-02 13:26:06 | 1 | Metro |
| 1108 | 1289 | 1 | 2015-10-02 14:44:44 | 1 | Walk |
| 1109 | 1288 | 1 | 2015-10-02 14:45:00 | 1 | Walk |
| 1110 | 1287 | 1 | 2015-10-02 14:45:18 | 1 | Walk |
| 1111 | 1268 | 2 | 2015-10-02 15:06:05 | 1 | Metro |
| 1112 | 1269 | 2 | 2015-10-02 15:06:18 | 1 | Metro |
| 1113 | 1271 | 2 | 2015-10-02 15:06:19 | 1 | Metro |
| 1114 | 1270 | 2 | 2015-10-02 15:06:20 | 1 | Metro |
| 1115 | 1267 | 2 | 2015-10-02 15:06:30 | 1 | Metro |
| 1116 | 1071 | 1 | 2015-10-04 10:38:13 | 1 | Walk |
| 1117 | 1070 | 1 | 2015-10-04 10:38:22 | 1 | Walk |
| 1118 | 1292 | 5 | 2015-10-04 12:47:38 | 1 | Walk |
| 1119 | 1294 | 5 | 2015-10-04 12:48:08 | 1 | Walk |
| 1120 | 1291 | 5 | 2015-10-04 12:48:11 | 1 | Walk |
| 1121 | 1293 | 5 | 2015-10-04 12:48:12 | 1 | Walk |
| 1122 | 1266 | 1 | 2015-10-05 10:30:27 | 1 | Other |
| 1123 | 1265 | 1 | 2015-10-05 10:30:38 | 1 | Other |
| 1124 | 1188 | 5 | 2015-10-07 13:26:45 | 1 | Walk |
| 1125 | 1189 | 5 | 2015-10-07 13:26:55 | 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;