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,201–9,225 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 9201 | 9430 | 1 | 2019-11-20 11:45:57 | 1 | Walk |
| 9202 | 9431 | 1 | 2019-11-20 11:46:22 | 1 | Walk |
| 9203 | 9432 | 1 | 2019-11-20 11:46:40 | 1 | Walk |
| 9204 | 9433 | 1 | 2019-11-20 11:46:46 | 1 | Walk |
| 9205 | 9443 | 1 | 2019-11-21 14:56:33 | 1 | Walk |
| 9206 | 9444 | 1 | 2019-11-21 14:56:46 | 1 | Walk |
| 9207 | 9445 | 1 | 2019-11-21 14:56:49 | 1 | Walk |
| 9208 | 9446 | 1 | 2019-11-21 14:56:50 | 1 | Walk |
| 9209 | 9447 | 1 | 2019-11-21 14:57:20 | 1 | Walk |
| 9210 | 9175 | 3 | 2019-11-22 11:36:27 | 1 | Walk |
| 9211 | 9462 | 1 | 2019-11-22 12:20:20 | 1 | Other |
| 9212 | 9461 | 1 | 2019-11-22 12:20:25 | 1 | Other |
| 9213 | 9459 | 1 | 2019-11-22 12:20:31 | 1 | Other |
| 9214 | 9460 | 1 | 2019-11-22 12:20:38 | 1 | Other |
| 9215 | 9427 | 3 | 2019-11-22 14:50:54 | 1 | Metro |
| 9216 | 9426 | 3 | 2019-11-22 14:51:15 | 1 | Metro |
| 9217 | 9397 | 4 | 2019-11-22 16:11:16 | 1 | Walk |
| 9218 | 9398 | 4 | 2019-11-22 16:11:26 | 1 | Walk |
| 9219 | 9466 | 1 | 2019-11-23 09:47:24 | 1 | Other |
| 9220 | 9465 | 1 | 2019-11-23 09:47:26 | 1 | Other |
| 9221 | 9467 | 1 | 2019-11-23 09:47:44 | 1 | Other |
| 9222 | 9457 | 2 | 2019-11-23 11:05:36 | 1 | Walk |
| 9223 | 9458 | 2 | 2019-11-23 11:05:42 | 1 | Walk |
| 9224 | 9454 | 2 | 2019-11-23 11:05:45 | 1 | Walk |
| 9225 | 9456 | 2 | 2019-11-23 11:06:03 | 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;