Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 9,676–9,700 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 9676 | 9791 | 1 | 2020-02-11 13:37:55 | 1 | Metro |
| 9677 | 9796 | 1 | 2020-02-13 13:44:48 | 1 | Walk |
| 9678 | 9795 | 1 | 2020-02-13 13:44:58 | 1 | Walk |
| 9679 | 9773 | 4 | 2020-02-15 09:36:55 | 1 | Taxi |
| 9680 | 9804 | 2 | 2020-02-15 09:40:19 | 1 | Walk |
| 9681 | 9794 | 3 | 2020-02-15 11:02:25 | 1 | Walk |
| 9682 | 9792 | 3 | 2020-02-15 11:02:44 | 1 | Walk |
| 9683 | 9793 | 3 | 2020-02-15 11:02:44 | 1 | Walk |
| 9684 | 9774 | 1 | 2020-02-15 11:46:49 | 1 | Walk |
| 9685 | 9813 | 3 | 2020-02-16 15:17:45 | 1 | Metro |
| 9686 | 9780 | 2 | 2020-02-16 16:07:19 | 1 | Metro |
| 9687 | 9779 | 2 | 2020-02-16 16:07:32 | 1 | Metro |
| 9688 | 9814 | 1 | 2020-02-17 09:15:43 | 1 | Metro |
| 9689 | 9815 | 1 | 2020-02-17 09:15:47 | 1 | Metro |
| 9690 | 9802 | 1 | 2020-02-17 10:54:29 | 1 | Walk |
| 9691 | 9803 | 1 | 2020-02-17 10:54:37 | 1 | Walk |
| 9692 | 9691 | 2 | 2020-02-17 11:37:14 | 1 | Private Vehicle |
| 9693 | 9692 | 2 | 2020-02-17 11:37:30 | 1 | Private Vehicle |
| 9694 | 9690 | 2 | 2020-02-17 11:37:56 | 1 | Private Vehicle |
| 9695 | 9811 | 2 | 2020-02-17 12:03:16 | 1 | Train |
| 9696 | 9817 | 1 | 2020-02-17 13:44:00 | 1 | Walk |
| 9697 | 9816 | 1 | 2020-02-17 13:44:16 | 1 | Walk |
| 9698 | 9818 | 1 | 2020-02-17 13:44:27 | 1 | Walk |
| 9699 | 9806 | 5 | 2020-02-18 10:28:35 | 1 | Metro |
| 9700 | 9805 | 5 | 2020-02-18 10:28:36 | 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;