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,776–3,800 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 3776 | 3887 | 3 | 2017-05-18 11:26:09 | 1 | Metro |
| 3777 | 3921 | 1 | 2017-05-18 11:46:36 | 1 | Train |
| 3778 | 3920 | 1 | 2017-05-18 11:47:05 | 1 | Train |
| 3779 | 3890 | 4 | 2017-05-18 14:15:19 | 0 | NULL |
| 3780 | 3888 | 2 | 2017-05-18 14:18:18 | 0 | NULL |
| 3781 | 3889 | 3 | 2017-05-18 14:25:08 | 0 | NULL |
| 3782 | 3887 | 3 | 2017-05-18 14:39:49 | 0 | NULL |
| 3783 | 3952 | 1 | 2017-05-19 11:07:35 | 1 | Other |
| 3784 | 3954 | 2 | 2017-05-20 09:47:56 | 1 | Metro |
| 3785 | 3953 | 2 | 2017-05-20 09:48:02 | 1 | Metro |
| 3786 | 3941 | 1 | 2017-05-20 12:04:51 | 1 | Other |
| 3787 | 3869 | 4 | 2017-05-20 13:03:06 | 1 | Taxi |
| 3788 | 3868 | 4 | 2017-05-20 13:03:26 | 1 | Taxi |
| 3789 | 3867 | 4 | 2017-05-20 13:03:48 | 1 | Taxi |
| 3790 | 3855 | 1 | 2017-05-20 15:53:14 | 1 | Metro |
| 3791 | 3955 | 1 | 2017-05-21 10:51:21 | 1 | Walk |
| 3792 | 3956 | 1 | 2017-05-21 10:51:38 | 1 | Walk |
| 3793 | 3895 | 1 | 2017-05-23 12:28:18 | 1 | Metro |
| 3794 | 3896 | 1 | 2017-05-23 12:28:39 | 1 | Metro |
| 3795 | 3917 | 1 | 2017-05-24 10:21:26 | 1 | Train |
| 3796 | 3918 | 1 | 2017-05-24 10:21:30 | 1 | Train |
| 3797 | 3940 | 5 | 2017-05-24 10:46:51 | 1 | Walk |
| 3798 | 3965 | 1 | 2017-05-25 14:21:40 | 1 | Metro |
| 3799 | 3968 | 1 | 2017-05-25 14:21:47 | 1 | Metro |
| 3800 | 3966 | 1 | 2017-05-25 14:21:58 | 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;