Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 8,801–8,825 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 8801 | 9097 | 4 | 2019-09-22 12:35:00 | 1 | Walk |
| 8802 | 9098 | 4 | 2019-09-22 12:35:20 | 1 | Walk |
| 8803 | 9099 | 4 | 2019-09-22 12:35:22 | 1 | Walk |
| 8804 | 9096 | 1 | 2019-09-22 13:19:51 | 1 | Bus |
| 8805 | 9086 | 4 | 2019-09-22 15:31:32 | 1 | Taxi |
| 8806 | 9085 | 4 | 2019-09-22 15:31:46 | 1 | Taxi |
| 8807 | 9108 | 1 | 2019-09-23 10:34:05 | 1 | Walk |
| 8808 | 9107 | 1 | 2019-09-23 10:34:34 | 1 | Walk |
| 8809 | 9092 | 1 | 2019-09-23 10:45:48 | 1 | Walk |
| 8810 | 9093 | 1 | 2019-09-23 10:45:49 | 1 | Walk |
| 8811 | 9091 | 1 | 2019-09-23 10:45:52 | 1 | Walk |
| 8812 | 9090 | 1 | 2019-09-23 10:46:23 | 1 | Walk |
| 8813 | 9089 | 5 | 2019-09-24 11:22:52 | 1 | Metro |
| 8814 | 8870 | 1 | 2019-09-24 11:33:28 | 1 | Metro |
| 8815 | 9115 | 1 | 2019-09-26 12:52:51 | 1 | Taxi |
| 8816 | 9117 | 1 | 2019-09-28 09:48:13 | 1 | Metro |
| 8817 | 9118 | 1 | 2019-09-28 09:48:22 | 1 | Metro |
| 8818 | 9120 | 2 | 2019-09-29 09:08:44 | 1 | Metro |
| 8819 | 9119 | 2 | 2019-09-29 09:08:53 | 1 | Metro |
| 8820 | 8869 | 2 | 2019-09-30 09:30:18 | 1 | Metro |
| 8821 | 8876 | 4 | 2019-09-30 11:08:33 | 1 | Bus |
| 8822 | 8875 | 4 | 2019-09-30 11:09:09 | 1 | Bus |
| 8823 | 8875 | 4 | 2019-09-30 14:03:02 | 0 | NULL |
| 8824 | 8876 | 4 | 2019-09-30 14:55:24 | 0 | NULL |
| 8825 | 9123 | 2 | 2019-10-03 09:09:49 | 1 | Metro |
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;