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,226–1,250 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 1226 | 1370 | 1 | 2015-10-31 10:04:22 | 1 | Metro |
| 1227 | 1368 | 1 | 2015-10-31 10:14:39 | 1 | Bus |
| 1228 | 1366 | 1 | 2015-10-31 10:14:45 | 1 | Bus |
| 1229 | 1364 | 1 | 2015-10-31 10:14:59 | 1 | Bus |
| 1230 | 1367 | 1 | 2015-10-31 10:15:09 | 1 | Bus |
| 1231 | 1365 | 1 | 2015-10-31 10:15:12 | 1 | Bus |
| 1232 | 1354 | 1 | 2015-10-31 12:17:55 | 1 | Metro |
| 1233 | 1353 | 1 | 2015-10-31 12:18:00 | 1 | Metro |
| 1234 | 1373 | 2 | 2015-11-02 10:43:24 | 1 | Taxi |
| 1235 | 1372 | 1 | 2015-11-03 10:35:58 | 1 | Walk |
| 1236 | 1359 | 1 | 2015-11-03 10:58:55 | 1 | Walk |
| 1237 | 1420 | 4 | 2015-11-04 10:29:28 | 1 | Train |
| 1238 | 1341 | 2 | 2015-11-04 11:59:24 | 1 | Walk |
| 1239 | 1342 | 2 | 2015-11-04 11:59:26 | 1 | Walk |
| 1240 | 1343 | 2 | 2015-11-04 11:59:38 | 1 | Walk |
| 1241 | 1417 | 2 | 2015-11-06 11:08:41 | 1 | Taxi |
| 1242 | 1416 | 4 | 2015-11-06 15:34:39 | 1 | Bus |
| 1243 | 1356 | 4 | 2015-11-08 10:42:34 | 1 | Walk |
| 1244 | 1329 | 2 | 2015-11-08 16:21:38 | 1 | Metro |
| 1245 | 1330 | 2 | 2015-11-08 16:21:43 | 1 | Metro |
| 1246 | 1328 | 2 | 2015-11-08 16:22:25 | 1 | Metro |
| 1247 | 1371 | 4 | 2015-11-09 12:04:03 | 1 | Metro |
| 1248 | 1427 | 2 | 2015-11-09 15:37:08 | 1 | Walk |
| 1249 | 1428 | 2 | 2015-11-09 15:37:19 | 1 | Walk |
| 1250 | 1134 | 4 | 2015-11-10 09:46:30 | 1 | Other |
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;