Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 7,826–7,850 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 7826 | 7696 | 4 | 2019-04-19 13:10:15 | 1 | Bus |
| 7827 | 7705 | 4 | 2019-04-19 13:10:21 | 1 | Bus |
| 7828 | 7709 | 4 | 2019-04-19 13:10:41 | 1 | Bus |
| 7829 | 7711 | 4 | 2019-04-19 13:10:46 | 1 | Bus |
| 7830 | 7684 | 4 | 2019-04-19 13:10:57 | 1 | Bus |
| 7831 | 7686 | 4 | 2019-04-19 13:11:01 | 1 | Bus |
| 7832 | 7708 | 4 | 2019-04-19 13:11:15 | 1 | Bus |
| 7833 | 7689 | 4 | 2019-04-19 13:11:34 | 1 | Bus |
| 7834 | 7706 | 4 | 2019-04-19 13:11:40 | 1 | Bus |
| 7835 | 7688 | 4 | 2019-04-19 13:11:45 | 1 | Bus |
| 7836 | 7698 | 4 | 2019-04-19 13:11:51 | 1 | Bus |
| 7837 | 7685 | 4 | 2019-04-19 13:12:06 | 1 | Bus |
| 7838 | 7692 | 4 | 2019-04-19 13:12:07 | 1 | Bus |
| 7839 | 7695 | 4 | 2019-04-19 13:12:29 | 1 | Bus |
| 7840 | 7690 | 4 | 2019-04-19 13:12:33 | 1 | Bus |
| 7841 | 7703 | 4 | 2019-04-19 13:13:01 | 1 | Bus |
| 7842 | 7707 | 4 | 2019-04-19 13:13:03 | 1 | Bus |
| 7843 | 7704 | 4 | 2019-04-19 13:13:46 | 1 | Bus |
| 7844 | 7702 | 4 | 2019-04-19 13:13:57 | 1 | Bus |
| 7845 | 8100 | 1 | 2019-04-20 11:46:24 | 1 | Bus |
| 7846 | 8099 | 1 | 2019-04-20 11:46:51 | 1 | Bus |
| 7847 | 8056 | 1 | 2019-04-21 12:58:45 | 1 | Walk |
| 7848 | 8104 | 3 | 2019-04-21 16:11:12 | 1 | Walk |
| 7849 | 8108 | 5 | 2019-04-22 09:52:32 | 1 | Walk |
| 7850 | 8107 | 5 | 2019-04-22 09:53:08 | 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;