Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 6,476–6,500 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 6476 | 6708 | 1 | 2018-09-18 11:42:26 | 1 | Walk |
| 6477 | 6733 | 1 | 2018-09-18 15:49:12 | 1 | Walk |
| 6478 | 6731 | 1 | 2018-09-18 15:49:22 | 1 | Walk |
| 6479 | 6730 | 1 | 2018-09-18 15:49:47 | 1 | Walk |
| 6480 | 6732 | 1 | 2018-09-18 15:49:52 | 1 | Walk |
| 6481 | 6609 | 1 | 2018-09-18 16:45:09 | 1 | Taxi |
| 6482 | 6610 | 1 | 2018-09-18 16:45:43 | 1 | Taxi |
| 6483 | 6731 | 1 | 2018-09-18 17:22:42 | 0 | NULL |
| 6484 | 6730 | 1 | 2018-09-18 17:22:52 | 0 | NULL |
| 6485 | 6733 | 1 | 2018-09-18 17:25:47 | 0 | NULL |
| 6486 | 6729 | 3 | 2018-09-19 10:24:54 | 1 | Walk |
| 6487 | 6734 | 4 | 2018-09-19 11:44:49 | 1 | Bus |
| 6488 | 6735 | 4 | 2018-09-19 11:45:16 | 1 | Bus |
| 6489 | 6736 | 4 | 2018-09-19 11:45:17 | 1 | Bus |
| 6490 | 6700 | 1 | 2018-09-19 11:59:21 | 1 | Other |
| 6491 | 6701 | 1 | 2018-09-19 11:59:25 | 1 | Other |
| 6492 | 6737 | 2 | 2018-09-20 11:30:25 | 1 | Bus |
| 6493 | 6738 | 2 | 2018-09-20 11:30:31 | 1 | Bus |
| 6494 | 6484 | 1 | 2018-09-20 14:05:38 | 1 | Metro |
| 6495 | 6741 | 1 | 2018-09-21 09:01:34 | 1 | Walk |
| 6496 | 6740 | 1 | 2018-09-21 09:01:47 | 1 | Walk |
| 6497 | 6740 | 1 | 2018-09-21 11:20:41 | 0 | NULL |
| 6498 | 6741 | 1 | 2018-09-21 11:42:13 | 0 | NULL |
| 6499 | 6692 | 1 | 2018-09-23 13:52:06 | 1 | Walk |
| 6500 | 6748 | 1 | 2018-09-23 14:00:18 | 1 | Train |
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;