Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 6,051–6,075 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 6051 | 6340 | 1 | 2018-08-02 11:41:01 | 1 | Metro |
| 6052 | 6341 | 1 | 2018-08-02 11:41:33 | 1 | Metro |
| 6053 | 6342 | 1 | 2018-08-02 11:51:54 | 1 | Metro |
| 6054 | 6306 | 5 | 2018-08-02 15:59:56 | 1 | Walk |
| 6055 | 6331 | 1 | 2018-08-02 16:04:08 | 1 | Walk |
| 6056 | 6329 | 1 | 2018-08-02 16:04:23 | 1 | Walk |
| 6057 | 6330 | 1 | 2018-08-02 16:04:45 | 1 | Walk |
| 6058 | 6328 | 1 | 2018-08-02 16:30:11 | 1 | Metro |
| 6059 | 6349 | 2 | 2018-08-03 11:09:31 | 1 | Bus |
| 6060 | 6347 | 2 | 2018-08-03 11:09:39 | 1 | Bus |
| 6061 | 6346 | 2 | 2018-08-03 11:09:59 | 1 | Bus |
| 6062 | 6348 | 2 | 2018-08-03 11:10:06 | 1 | Bus |
| 6063 | 6344 | 1 | 2018-08-04 11:59:19 | 1 | Bus |
| 6064 | 6343 | 1 | 2018-08-04 11:59:20 | 1 | Bus |
| 6065 | 6391 | 1 | 2018-08-04 13:11:10 | 1 | Taxi |
| 6066 | 6390 | 1 | 2018-08-04 13:11:20 | 1 | Taxi |
| 6067 | 6392 | 1 | 2018-08-04 13:11:21 | 1 | Taxi |
| 6068 | 6393 | 1 | 2018-08-04 13:11:26 | 1 | Taxi |
| 6069 | 6394 | 5 | 2018-08-04 16:49:04 | 1 | Walk |
| 6070 | 6395 | 5 | 2018-08-04 16:49:50 | 1 | Walk |
| 6071 | 6396 | 1 | 2018-08-05 11:05:10 | 1 | Train |
| 6072 | 6399 | 1 | 2018-08-05 13:00:20 | 1 | Walk |
| 6073 | 6400 | 1 | 2018-08-05 13:00:47 | 1 | Walk |
| 6074 | 6398 | 1 | 2018-08-05 13:01:01 | 1 | Walk |
| 6075 | 6397 | 1 | 2018-08-05 13:01:05 | 1 | Walk |
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;