Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 9,076–9,100 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 9076 | 8924 | 1 | 2019-11-05 10:02:15 | 1 | Bus |
| 9077 | 8946 | 1 | 2019-11-05 10:02:21 | 1 | Bus |
| 9078 | 8943 | 1 | 2019-11-05 10:02:35 | 1 | Bus |
| 9079 | 8928 | 1 | 2019-11-05 10:02:42 | 1 | Bus |
| 9080 | 8938 | 1 | 2019-11-05 10:02:43 | 1 | Bus |
| 9081 | 8936 | 1 | 2019-11-05 10:02:54 | 1 | Bus |
| 9082 | 8947 | 1 | 2019-11-05 10:03:03 | 1 | Bus |
| 9083 | 8945 | 1 | 2019-11-05 10:03:57 | 1 | Bus |
| 9084 | 8942 | 1 | 2019-11-05 10:05:34 | 1 | Bus |
| 9085 | 8944 | 1 | 2019-11-05 10:06:00 | 1 | Bus |
| 9086 | 9366 | 2 | 2019-11-06 09:09:58 | 1 | Metro |
| 9087 | 9367 | 2 | 2019-11-06 09:10:01 | 1 | Metro |
| 9088 | 9338 | 1 | 2019-11-06 09:32:02 | 1 | Walk |
| 9089 | 9337 | 1 | 2019-11-06 09:32:06 | 1 | Walk |
| 9090 | 9368 | 3 | 2019-11-07 09:15:14 | 1 | Metro |
| 9091 | 9369 | 3 | 2019-11-07 09:15:36 | 1 | Metro |
| 9092 | 9357 | 3 | 2019-11-07 09:49:34 | 1 | Metro |
| 9093 | 9358 | 3 | 2019-11-07 09:49:42 | 1 | Metro |
| 9094 | 9347 | 3 | 2019-11-07 12:52:44 | 1 | Bus |
| 9095 | 9346 | 3 | 2019-11-07 12:53:18 | 1 | Bus |
| 9096 | 9370 | 1 | 2019-11-07 14:06:24 | 1 | Walk |
| 9097 | 9373 | 5 | 2019-11-08 10:07:29 | 1 | Metro |
| 9098 | 9374 | 5 | 2019-11-08 10:08:06 | 1 | Metro |
| 9099 | 9378 | 2 | 2019-11-08 12:40:22 | 1 | Bus |
| 9100 | 9291 | 1 | 2019-11-08 12:51:25 | 1 | Taxi |
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;