Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 4,426–4,450 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 4426 | 4206 | 1 | 2017-09-20 12:34:39 | 1 | Other |
| 4427 | 4208 | 1 | 2017-09-20 12:34:49 | 1 | Other |
| 4428 | 4228 | 1 | 2017-09-20 12:34:57 | 1 | Other |
| 4429 | 4215 | 1 | 2017-09-20 12:35:02 | 1 | Other |
| 4430 | 4219 | 1 | 2017-09-20 12:35:07 | 1 | Other |
| 4431 | 4216 | 1 | 2017-09-20 12:35:09 | 1 | Other |
| 4432 | 4214 | 1 | 2017-09-20 12:35:13 | 1 | Other |
| 4433 | 4207 | 1 | 2017-09-20 12:35:23 | 1 | Other |
| 4434 | 4211 | 1 | 2017-09-20 12:35:34 | 1 | Other |
| 4435 | 4229 | 1 | 2017-09-20 12:35:34 | 1 | Other |
| 4436 | 4210 | 1 | 2017-09-20 12:35:37 | 1 | Other |
| 4437 | 4213 | 1 | 2017-09-20 12:36:13 | 1 | Other |
| 4438 | 4220 | 1 | 2017-09-20 12:36:25 | 1 | Other |
| 4439 | 4221 | 1 | 2017-09-20 12:36:34 | 1 | Other |
| 4440 | 4222 | 1 | 2017-09-20 12:37:09 | 1 | Other |
| 4441 | 4225 | 1 | 2017-09-20 12:37:10 | 1 | Other |
| 4442 | 4218 | 1 | 2017-09-20 12:37:13 | 1 | Other |
| 4443 | 4217 | 1 | 2017-09-20 12:37:43 | 1 | Other |
| 4444 | 4226 | 1 | 2017-09-20 12:38:19 | 1 | Other |
| 4445 | 4227 | 1 | 2017-09-20 12:39:01 | 1 | Other |
| 4446 | 4224 | 1 | 2017-09-20 12:39:21 | 1 | Other |
| 4447 | 4237 | 1 | 2017-09-20 12:39:39 | 1 | Other |
| 4448 | 4235 | 1 | 2017-09-20 12:39:58 | 1 | Other |
| 4449 | 4230 | 1 | 2017-09-20 12:40:11 | 1 | Other |
| 4450 | 4232 | 1 | 2017-09-20 12:40:37 | 1 | Other |
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;