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,551–4,575 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 4551 | 4632 | 1 | 2017-10-10 09:39:35 | 1 | Bus |
| 4552 | 4634 | 1 | 2017-10-10 09:40:01 | 1 | Bus |
| 4553 | 4630 | 1 | 2017-10-10 09:40:21 | 1 | Bus |
| 4554 | 4631 | 1 | 2017-10-10 09:40:36 | 1 | Bus |
| 4555 | 4635 | 1 | 2017-10-10 09:40:55 | 1 | Bus |
| 4556 | 4764 | 1 | 2017-10-10 10:46:57 | 1 | Walk |
| 4557 | 4748 | 3 | 2017-10-10 11:37:33 | 1 | Bus |
| 4558 | 4758 | 2 | 2017-10-10 15:36:40 | 1 | Metro |
| 4559 | 4760 | 2 | 2017-10-10 15:36:53 | 1 | Metro |
| 4560 | 4759 | 2 | 2017-10-10 15:36:57 | 1 | Metro |
| 4561 | 4761 | 2 | 2017-10-10 15:36:59 | 1 | Metro |
| 4562 | 4755 | 1 | 2017-10-11 11:03:05 | 1 | Walk |
| 4563 | 4753 | 1 | 2017-10-11 11:03:16 | 1 | Walk |
| 4564 | 4754 | 1 | 2017-10-11 11:03:19 | 1 | Walk |
| 4565 | 4756 | 1 | 2017-10-11 11:03:24 | 1 | Walk |
| 4566 | 4765 | 1 | 2017-10-11 11:14:10 | 1 | Metro |
| 4567 | 4766 | 2 | 2017-10-12 10:14:20 | 1 | Walk |
| 4568 | 4769 | 1 | 2017-10-14 14:52:32 | 1 | Walk |
| 4569 | 4770 | 1 | 2017-10-15 12:58:12 | 1 | Taxi |
| 4570 | 4771 | 1 | 2017-10-15 12:58:32 | 1 | Taxi |
| 4571 | 4772 | 1 | 2017-10-15 12:58:55 | 1 | Taxi |
| 4572 | 4773 | 1 | 2017-10-15 13:58:47 | 1 | Metro |
| 4573 | 4776 | 5 | 2017-10-17 16:23:56 | 1 | Metro |
| 4574 | 4778 | 5 | 2017-10-17 16:24:15 | 1 | Metro |
| 4575 | 4775 | 5 | 2017-10-17 16:24: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;