Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 7,876–7,900 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 7876 | 8133 | 3 | 2019-04-26 10:23:38 | 1 | Walk |
| 7877 | 8101 | 5 | 2019-04-27 11:45:50 | 1 | Walk |
| 7878 | 8132 | 1 | 2019-04-28 09:33:33 | 1 | Train |
| 7879 | 8131 | 1 | 2019-04-28 09:33:59 | 1 | Train |
| 7880 | 8141 | 5 | 2019-04-29 11:51:51 | 1 | Bus |
| 7881 | 8142 | 5 | 2019-04-29 11:52:33 | 1 | Bus |
| 7882 | 8059 | 2 | 2019-04-29 12:27:45 | 1 | Metro |
| 7883 | 8057 | 2 | 2019-04-29 12:27:52 | 1 | Metro |
| 7884 | 8060 | 2 | 2019-04-29 12:28:29 | 1 | Metro |
| 7885 | 8058 | 2 | 2019-04-29 12:28:34 | 1 | Metro |
| 7886 | 8145 | 1 | 2019-04-29 14:43:41 | 1 | Walk |
| 7887 | 8144 | 1 | 2019-04-29 14:43:54 | 1 | Walk |
| 7888 | 8148 | 1 | 2019-04-30 10:24:12 | 1 | Walk |
| 7889 | 8147 | 1 | 2019-04-30 10:24:17 | 1 | Walk |
| 7890 | 8148 | 5 | 2019-04-30 12:33:10 | 0 | NULL |
| 7891 | 8147 | 1 | 2019-04-30 12:59:46 | 0 | NULL |
| 7892 | 8149 | 2 | 2019-04-30 13:12:21 | 1 | Walk |
| 7893 | 8153 | 1 | 2019-04-30 13:34:57 | 1 | Taxi |
| 7894 | 8154 | 1 | 2019-04-30 13:35:41 | 1 | Taxi |
| 7895 | 8149 | 3 | 2019-04-30 15:21:18 | 0 | NULL |
| 7896 | 8146 | 3 | 2019-05-01 09:08:01 | 1 | Taxi |
| 7897 | 8158 | 2 | 2019-05-02 11:26:49 | 1 | Metro |
| 7898 | 8157 | 2 | 2019-05-02 11:26:59 | 1 | Metro |
| 7899 | 8081 | 1 | 2019-05-03 09:57:57 | 1 | Walk |
| 7900 | 8150 | 3 | 2019-05-03 10:00:15 | 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;