Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 5,901–5,925 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 5901 | 5967 | 4 | 2018-07-17 09:53:33 | 1 | Other |
| 5902 | 5977 | 4 | 2018-07-17 09:53:37 | 1 | Other |
| 5903 | 5968 | 4 | 2018-07-17 09:53:39 | 1 | Other |
| 5904 | 5981 | 4 | 2018-07-17 09:53:40 | 1 | Other |
| 5905 | 5974 | 4 | 2018-07-17 09:53:47 | 1 | Other |
| 5906 | 5979 | 4 | 2018-07-17 09:53:49 | 1 | Other |
| 5907 | 5971 | 4 | 2018-07-17 09:53:56 | 1 | Other |
| 5908 | 5969 | 4 | 2018-07-17 09:54:10 | 1 | Other |
| 5909 | 5983 | 4 | 2018-07-17 09:54:13 | 1 | Other |
| 5910 | 5980 | 4 | 2018-07-17 09:54:35 | 1 | Other |
| 5911 | 5976 | 4 | 2018-07-17 09:54:51 | 1 | Other |
| 5912 | 5978 | 4 | 2018-07-17 09:54:55 | 1 | Other |
| 5913 | 5984 | 4 | 2018-07-17 09:55:07 | 1 | Other |
| 5914 | 5999 | 4 | 2018-07-17 09:55:10 | 1 | Other |
| 5915 | 6009 | 4 | 2018-07-17 09:55:11 | 1 | Other |
| 5916 | 6001 | 4 | 2018-07-17 09:55:20 | 1 | Other |
| 5917 | 6013 | 4 | 2018-07-17 09:55:27 | 1 | Other |
| 5918 | 5982 | 4 | 2018-07-17 09:55:35 | 1 | Other |
| 5919 | 5975 | 4 | 2018-07-17 09:55:40 | 1 | Other |
| 5920 | 5986 | 4 | 2018-07-17 09:55:49 | 1 | Other |
| 5921 | 5991 | 4 | 2018-07-17 09:56:03 | 1 | Other |
| 5922 | 5987 | 4 | 2018-07-17 09:56:25 | 1 | Other |
| 5923 | 6014 | 4 | 2018-07-17 09:56:25 | 1 | Other |
| 5924 | 6006 | 4 | 2018-07-17 09:56:31 | 1 | Other |
| 5925 | 5993 | 4 | 2018-07-17 09:56:52 | 1 | Other |
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;