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,201–6,225 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 6201 | 6244 | 1 | 2018-08-18 14:56:43 | 1 | Walk |
| 6202 | 6245 | 1 | 2018-08-18 14:56:47 | 1 | Walk |
| 6203 | 6246 | 1 | 2018-08-18 14:56:48 | 1 | Walk |
| 6204 | 6492 | 3 | 2018-08-18 15:53:00 | 1 | Metro |
| 6205 | 6493 | 3 | 2018-08-18 15:53:25 | 1 | Metro |
| 6206 | 6495 | 2 | 2018-08-19 09:12:24 | 1 | Metro |
| 6207 | 6498 | 4 | 2018-08-19 11:08:07 | 1 | Bus |
| 6208 | 6496 | 4 | 2018-08-19 11:08:18 | 1 | Bus |
| 6209 | 6497 | 4 | 2018-08-19 11:08:40 | 1 | Bus |
| 6210 | 6500 | 4 | 2018-08-19 12:46:04 | 1 | Other |
| 6211 | 6499 | 4 | 2018-08-19 12:46:05 | 1 | Other |
| 6212 | 6333 | 1 | 2018-08-19 15:22:25 | 1 | Taxi |
| 6213 | 6332 | 1 | 2018-08-19 15:22:35 | 1 | Taxi |
| 6214 | 6336 | 1 | 2018-08-19 15:22:50 | 1 | Taxi |
| 6215 | 6335 | 1 | 2018-08-19 15:22:52 | 1 | Taxi |
| 6216 | 6334 | 1 | 2018-08-19 15:23:00 | 1 | Taxi |
| 6217 | 6462 | 2 | 2018-08-19 15:37:18 | 1 | Train |
| 6218 | 6463 | 2 | 2018-08-19 15:37:32 | 1 | Train |
| 6219 | 6407 | 3 | 2018-08-20 10:36:02 | 1 | Bus |
| 6220 | 6503 | 1 | 2018-08-20 12:53:24 | 1 | Walk |
| 6221 | 6504 | 1 | 2018-08-20 12:53:28 | 1 | Walk |
| 6222 | 6505 | 5 | 2018-08-21 09:35:16 | 1 | Walk |
| 6223 | 6506 | 5 | 2018-08-21 09:35:50 | 1 | Walk |
| 6224 | 6299 | 1 | 2018-08-21 09:43:34 | 1 | Walk |
| 6225 | 6466 | 3 | 2018-08-22 09:38:16 | 1 | Metro |
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;