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,751–3,775 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 3751 | 3929 | 2 | 2017-05-12 09:10:12 | 1 | Metro |
| 3752 | 3930 | 2 | 2017-05-12 09:10:20 | 1 | Metro |
| 3753 | 3935 | 3 | 2017-05-12 14:11:40 | 1 | Walk |
| 3754 | 3935 | 3 | 2017-05-12 16:13:30 | 0 | NULL |
| 3755 | 3908 | 3 | 2017-05-12 16:39:54 | 1 | Metro |
| 3756 | 3909 | 3 | 2017-05-12 16:39:59 | 1 | Metro |
| 3757 | 3911 | 3 | 2017-05-12 16:40:18 | 1 | Metro |
| 3758 | 3910 | 3 | 2017-05-12 16:40:21 | 1 | Metro |
| 3759 | 3932 | 3 | 2017-05-13 09:43:12 | 1 | Walk |
| 3760 | 3933 | 3 | 2017-05-13 09:43:13 | 1 | Walk |
| 3761 | 3934 | 3 | 2017-05-13 09:43:25 | 1 | Walk |
| 3762 | 3931 | 3 | 2017-05-13 09:43:28 | 1 | Walk |
| 3763 | 3936 | 5 | 2017-05-13 12:27:02 | 1 | Walk |
| 3764 | 3939 | 1 | 2017-05-13 15:41:00 | 1 | Metro |
| 3765 | 3938 | 1 | 2017-05-13 15:41:02 | 1 | Metro |
| 3766 | 3937 | 1 | 2017-05-13 15:41:17 | 1 | Metro |
| 3767 | 3916 | 1 | 2017-05-14 14:02:23 | 1 | Other |
| 3768 | 3915 | 1 | 2017-05-14 14:02:28 | 1 | Other |
| 3769 | 3901 | 3 | 2017-05-16 12:54:13 | 1 | Metro |
| 3770 | 3948 | 1 | 2017-05-18 09:32:50 | 1 | Walk |
| 3771 | 3949 | 1 | 2017-05-18 09:33:02 | 1 | Walk |
| 3772 | 3942 | 2 | 2017-05-18 10:09:40 | 1 | Train |
| 3773 | 3890 | 3 | 2017-05-18 11:25:30 | 1 | Metro |
| 3774 | 3889 | 3 | 2017-05-18 11:25:48 | 1 | Metro |
| 3775 | 3888 | 3 | 2017-05-18 11:25:52 | 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;