Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 5,751–5,775 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 5751 | 6057 | 2 | 2018-06-17 12:27:15 | 1 | Metro |
| 5752 | 6059 | 2 | 2018-06-17 12:27:18 | 1 | Metro |
| 5753 | 6027 | 2 | 2018-06-17 13:24:58 | 0 | NULL |
| 5754 | 6026 | 1 | 2018-06-17 15:03:50 | 0 | NULL |
| 5755 | 5865 | 1 | 2018-06-17 15:53:19 | 1 | Train |
| 5756 | 5867 | 1 | 2018-06-17 15:53:25 | 1 | Train |
| 5757 | 5866 | 1 | 2018-06-17 15:53:39 | 1 | Train |
| 5758 | 6061 | 1 | 2018-06-18 15:58:02 | 1 | Bus |
| 5759 | 6060 | 1 | 2018-06-18 15:58:31 | 1 | Bus |
| 5760 | 6062 | 1 | 2018-06-19 10:33:52 | 1 | Metro |
| 5761 | 6063 | 1 | 2018-06-19 10:33:58 | 1 | Metro |
| 5762 | 5957 | 5 | 2018-06-20 10:45:21 | 1 | Walk |
| 5763 | 5958 | 5 | 2018-06-20 10:45:23 | 1 | Walk |
| 5764 | 6067 | 1 | 2018-06-21 09:20:51 | 1 | Walk |
| 5765 | 6066 | 1 | 2018-06-21 09:20:57 | 1 | Walk |
| 5766 | 6071 | 2 | 2018-06-21 11:47:12 | 1 | Bus |
| 5767 | 6072 | 5 | 2018-06-22 14:16:00 | 1 | Walk |
| 5768 | 6055 | 1 | 2018-06-22 14:39:28 | 1 | Walk |
| 5769 | 6054 | 1 | 2018-06-22 14:39:31 | 1 | Walk |
| 5770 | 6070 | 1 | 2018-06-23 09:12:33 | 1 | Bus |
| 5771 | 6019 | 2 | 2018-06-23 13:59:31 | 1 | Metro |
| 5772 | 6018 | 2 | 2018-06-23 13:59:41 | 1 | Metro |
| 5773 | 6020 | 2 | 2018-06-23 13:59:41 | 1 | Metro |
| 5774 | 5889 | 5 | 2018-06-24 09:42:01 | 1 | Walk |
| 5775 | 5886 | 5 | 2018-06-24 09:42:10 | 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;