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,676–8,700 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 8676 | 8803 | 1 | 2019-08-28 11:28:06 | 1 | Taxi |
| 8677 | 8832 | 1 | 2019-08-28 13:36:22 | 1 | Walk |
| 8678 | 8831 | 1 | 2019-08-28 13:36:42 | 1 | Walk |
| 8679 | 8775 | 2 | 2019-08-28 16:34:42 | 1 | Private Vehicle |
| 8680 | 8774 | 2 | 2019-08-28 16:34:54 | 1 | Private Vehicle |
| 8681 | 8846 | 2 | 2019-08-29 09:39:35 | 1 | Walk |
| 8682 | 8847 | 2 | 2019-08-29 09:39:52 | 1 | Walk |
| 8683 | 8789 | 4 | 2019-08-29 10:46:02 | 1 | Metro |
| 8684 | 8788 | 4 | 2019-08-29 10:46:18 | 1 | Metro |
| 8685 | 8855 | 1 | 2019-08-30 09:35:00 | 1 | Metro |
| 8686 | 8854 | 1 | 2019-08-30 09:35:08 | 1 | Metro |
| 8687 | 8857 | 1 | 2019-08-30 10:28:09 | 1 | Walk |
| 8688 | 8858 | 1 | 2019-08-30 10:28:34 | 1 | Walk |
| 8689 | 8856 | 1 | 2019-08-30 10:28:44 | 1 | Walk |
| 8690 | 8865 | 2 | 2019-08-31 10:13:21 | 1 | Metro |
| 8691 | 8864 | 2 | 2019-08-31 10:13:40 | 1 | Metro |
| 8692 | 8828 | 1 | 2019-08-31 10:21:49 | 1 | Walk |
| 8693 | 8867 | 1 | 2019-08-31 10:31:51 | 1 | Other |
| 8694 | 8825 | 2 | 2019-08-31 10:32:06 | 1 | Metro |
| 8695 | 8866 | 1 | 2019-08-31 10:32:09 | 1 | Other |
| 8696 | 8824 | 2 | 2019-08-31 10:32:25 | 1 | Metro |
| 8697 | 8827 | 2 | 2019-08-31 10:32:28 | 1 | Metro |
| 8698 | 8826 | 2 | 2019-08-31 10:32:30 | 1 | Metro |
| 8699 | 8852 | 1 | 2019-08-31 12:31:51 | 1 | Metro |
| 8700 | 8853 | 1 | 2019-08-31 12:31:51 | 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;