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,376–1,400 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 1376 | 1558 | 4 | 2015-12-06 09:59:13 | 1 | Walk |
| 1377 | 1556 | 4 | 2015-12-06 09:59:27 | 1 | Walk |
| 1378 | 1559 | 3 | 2015-12-06 10:23:47 | 1 | Walk |
| 1379 | 1556 | 4 | 2015-12-06 11:32:23 | 0 | NULL |
| 1380 | 1455 | 1 | 2015-12-06 11:50:00 | 1 | Walk |
| 1381 | 1454 | 1 | 2015-12-06 11:50:36 | 1 | Walk |
| 1382 | 1538 | 3 | 2015-12-06 11:51:56 | 1 | Walk |
| 1383 | 1536 | 3 | 2015-12-06 11:52:11 | 1 | Walk |
| 1384 | 1537 | 3 | 2015-12-06 11:52:16 | 1 | Walk |
| 1385 | 1535 | 3 | 2015-12-06 11:52:36 | 1 | Walk |
| 1386 | 1539 | 3 | 2015-12-06 11:52:38 | 1 | Walk |
| 1387 | 1557 | 3 | 2015-12-06 12:57:50 | 0 | NULL |
| 1388 | 1558 | 4 | 2015-12-06 13:10:27 | 0 | NULL |
| 1389 | 1555 | 3 | 2015-12-06 13:17:07 | 0 | NULL |
| 1390 | 1560 | 5 | 2015-12-06 14:29:20 | 1 | Taxi |
| 1391 | 1561 | 5 | 2015-12-06 14:29:23 | 1 | Taxi |
| 1392 | 1564 | 1 | 2015-12-06 15:00:14 | 1 | Bus |
| 1393 | 1563 | 1 | 2015-12-06 15:00:19 | 1 | Bus |
| 1394 | 1565 | 1 | 2015-12-06 15:00:24 | 1 | Bus |
| 1395 | 1562 | 1 | 2015-12-06 15:00:30 | 1 | Bus |
| 1396 | 1374 | 1 | 2015-12-07 12:06:00 | 1 | Bus |
| 1397 | 1375 | 1 | 2015-12-07 12:06:07 | 1 | Bus |
| 1398 | 1376 | 1 | 2015-12-07 12:06:18 | 1 | Bus |
| 1399 | 1379 | 1 | 2015-12-07 12:06:20 | 1 | Bus |
| 1400 | 1378 | 1 | 2015-12-07 12:06:28 | 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;