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,351–4,375 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 4351 | 4548 | 1 | 2017-09-06 15:15:25 | 1 | Walk |
| 4352 | 4545 | 1 | 2017-09-06 15:15:34 | 1 | Walk |
| 4353 | 4547 | 1 | 2017-09-06 15:15:41 | 1 | Walk |
| 4354 | 4546 | 1 | 2017-09-06 15:15:58 | 1 | Walk |
| 4355 | 4551 | 3 | 2017-09-06 15:36:40 | 0 | NULL |
| 4356 | 4550 | 3 | 2017-09-06 16:10:34 | 0 | NULL |
| 4357 | 4366 | 1 | 2017-09-07 13:12:05 | 1 | Bus |
| 4358 | 4365 | 1 | 2017-09-07 13:12:29 | 1 | Bus |
| 4359 | 4559 | 5 | 2017-09-07 16:20:32 | 1 | Metro |
| 4360 | 4560 | 5 | 2017-09-07 16:20:50 | 1 | Metro |
| 4361 | 4561 | 5 | 2017-09-07 16:20:55 | 1 | Metro |
| 4362 | 4562 | 4 | 2017-09-08 11:24:32 | 1 | Walk |
| 4363 | 4393 | 5 | 2017-09-08 12:24:15 | 1 | Walk |
| 4364 | 4553 | 1 | 2017-09-09 10:18:17 | 1 | Bus |
| 4365 | 4531 | 2 | 2017-09-10 11:06:53 | 1 | Walk |
| 4366 | 4563 | 1 | 2017-09-10 11:22:58 | 1 | Metro |
| 4367 | 4564 | 1 | 2017-09-10 11:23:28 | 1 | Metro |
| 4368 | 4420 | 1 | 2017-09-10 12:38:19 | 1 | Bus |
| 4369 | 4419 | 1 | 2017-09-10 12:39:00 | 1 | Bus |
| 4370 | 4538 | 4 | 2017-09-11 10:44:49 | 1 | Train |
| 4371 | 4539 | 4 | 2017-09-11 10:44:53 | 1 | Train |
| 4372 | 4537 | 4 | 2017-09-11 10:45:22 | 1 | Train |
| 4373 | 4568 | 5 | 2017-09-11 10:48:21 | 1 | Metro |
| 4374 | 4569 | 5 | 2017-09-11 10:48:41 | 1 | Metro |
| 4375 | 4567 | 5 | 2017-09-11 10:48:46 | 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;