Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 3,801–3,825 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 3801 | 3967 | 1 | 2017-05-25 14:22:13 | 1 | Metro |
| 3802 | 3870 | 1 | 2017-05-27 14:36:57 | 1 | Other |
| 3803 | 3871 | 1 | 2017-05-27 14:37:37 | 1 | Other |
| 3804 | 3959 | 1 | 2017-05-27 14:56:32 | 1 | Walk |
| 3805 | 3957 | 1 | 2017-05-27 14:56:43 | 1 | Walk |
| 3806 | 3958 | 1 | 2017-05-27 14:56:53 | 1 | Walk |
| 3807 | 3957 | 1 | 2017-05-27 16:37:13 | 0 | NULL |
| 3808 | 3958 | 1 | 2017-05-27 16:42:43 | 0 | NULL |
| 3809 | 3951 | 2 | 2017-05-28 09:23:55 | 1 | Walk |
| 3810 | 3950 | 2 | 2017-05-28 09:24:05 | 1 | Walk |
| 3811 | 3963 | 4 | 2017-05-28 09:59:29 | 1 | Walk |
| 3812 | 3962 | 4 | 2017-05-28 09:59:37 | 1 | Walk |
| 3813 | 3964 | 4 | 2017-05-28 09:59:41 | 1 | Walk |
| 3814 | 3973 | 5 | 2017-05-28 11:09:50 | 1 | Walk |
| 3815 | 3972 | 5 | 2017-05-28 11:09:58 | 1 | Walk |
| 3816 | 3974 | 2 | 2017-05-28 11:25:22 | 1 | Walk |
| 3817 | 3975 | 1 | 2017-05-28 12:09:18 | 1 | Walk |
| 3818 | 3976 | 1 | 2017-05-29 10:56:21 | 1 | Bus |
| 3819 | 3977 | 1 | 2017-05-29 15:12:26 | 1 | Metro |
| 3820 | 3981 | 2 | 2017-06-01 10:50:01 | 1 | Walk |
| 3821 | 3982 | 2 | 2017-06-01 10:50:43 | 1 | Walk |
| 3822 | 3980 | 1 | 2017-06-04 10:10:50 | 1 | Taxi |
| 3823 | 3990 | 1 | 2017-06-04 11:25:39 | 1 | Walk |
| 3824 | 3989 | 1 | 2017-06-04 11:25:44 | 1 | Walk |
| 3825 | 3988 | 1 | 2017-06-04 11:25:52 | 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;