Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 8,401–8,425 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 8401 | 8559 | 4 | 2019-07-15 13:54:51 | 0 | NULL |
| 8402 | 8387 | 2 | 2019-07-15 14:06:57 | 0 | NULL |
| 8403 | 8558 | 3 | 2019-07-16 09:35:46 | 1 | Metro |
| 8404 | 8529 | 5 | 2019-07-16 11:17:04 | 1 | Walk |
| 8405 | 8531 | 5 | 2019-07-16 11:17:06 | 1 | Walk |
| 8406 | 8530 | 5 | 2019-07-16 11:17:08 | 1 | Walk |
| 8407 | 8399 | 1 | 2019-07-16 11:22:10 | 1 | Metro |
| 8408 | 8560 | 2 | 2019-07-18 12:00:02 | 1 | Other |
| 8409 | 8566 | 1 | 2019-07-19 09:34:11 | 1 | Walk |
| 8410 | 8565 | 1 | 2019-07-19 09:34:39 | 1 | Walk |
| 8411 | 8573 | 4 | 2019-07-19 11:02:00 | 1 | Bus |
| 8412 | 8552 | 1 | 2019-07-19 12:38:16 | 1 | Taxi |
| 8413 | 8553 | 1 | 2019-07-19 12:38:24 | 1 | Taxi |
| 8414 | 8571 | 2 | 2019-07-19 14:59:45 | 1 | Metro |
| 8415 | 8572 | 2 | 2019-07-19 14:59:54 | 1 | Metro |
| 8416 | 8570 | 2 | 2019-07-19 15:00:03 | 1 | Metro |
| 8417 | 8577 | 1 | 2019-07-20 10:07:32 | 1 | Bus |
| 8418 | 8576 | 1 | 2019-07-20 10:07:34 | 1 | Bus |
| 8419 | 8578 | 1 | 2019-07-20 10:08:09 | 1 | Bus |
| 8420 | 8579 | 1 | 2019-07-20 10:08:12 | 1 | Bus |
| 8421 | 8549 | 1 | 2019-07-20 10:46:21 | 1 | Walk |
| 8422 | 8581 | 1 | 2019-07-20 12:19:31 | 1 | Walk |
| 8423 | 8580 | 1 | 2019-07-20 12:19:59 | 1 | Walk |
| 8424 | 8562 | 3 | 2019-07-20 13:49:58 | 1 | Metro |
| 8425 | 8563 | 3 | 2019-07-20 13:50:08 | 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;