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,976–4,000 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 3976 | 4143 | 2 | 2017-06-30 14:32:20 | 1 | Metro |
| 3977 | 4062 | 1 | 2017-06-30 14:44:52 | 1 | Walk |
| 3978 | 4154 | 1 | 2017-07-01 09:22:52 | 1 | Bus |
| 3979 | 4155 | 1 | 2017-07-01 09:22:53 | 1 | Bus |
| 3980 | 4157 | 1 | 2017-07-01 09:23:01 | 1 | Bus |
| 3981 | 4156 | 1 | 2017-07-01 09:23:09 | 1 | Bus |
| 3982 | 4046 | 1 | 2017-07-01 11:11:18 | 1 | Taxi |
| 3983 | 4044 | 1 | 2017-07-01 11:11:22 | 1 | Taxi |
| 3984 | 4045 | 1 | 2017-07-01 11:11:43 | 1 | Taxi |
| 3985 | 4159 | 5 | 2017-07-01 12:41:21 | 1 | Walk |
| 3986 | 4158 | 5 | 2017-07-01 12:41:53 | 1 | Walk |
| 3987 | 4150 | 1 | 2017-07-01 12:57:25 | 1 | Metro |
| 3988 | 4153 | 1 | 2017-07-01 12:57:33 | 1 | Metro |
| 3989 | 4152 | 1 | 2017-07-01 12:57:37 | 1 | Metro |
| 3990 | 4151 | 1 | 2017-07-01 12:57:55 | 1 | Metro |
| 3991 | 4161 | 1 | 2017-07-01 15:31:21 | 1 | Metro |
| 3992 | 4160 | 1 | 2017-07-01 15:31:46 | 1 | Metro |
| 3993 | 4163 | 1 | 2017-07-01 15:31:49 | 1 | Metro |
| 3994 | 4162 | 1 | 2017-07-01 15:32:01 | 1 | Metro |
| 3995 | 3637 | 4 | 2017-07-02 09:58:19 | 1 | Bus |
| 3996 | 3638 | 4 | 2017-07-02 09:58:28 | 1 | Bus |
| 3997 | 3644 | 4 | 2017-07-02 09:58:39 | 1 | Bus |
| 3998 | 3639 | 4 | 2017-07-02 09:58:43 | 1 | Bus |
| 3999 | 3640 | 4 | 2017-07-02 09:58:52 | 1 | Bus |
| 4000 | 3647 | 4 | 2017-07-02 09:59:07 | 1 | Bus |
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;