Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 2,326–2,350 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 2326 | 1923 | 1 | 2016-07-01 13:47:17 | 1 | Bus |
| 2327 | 1920 | 1 | 2016-07-01 13:47:18 | 1 | Bus |
| 2328 | 1948 | 1 | 2016-07-01 13:47:18 | 1 | Bus |
| 2329 | 1941 | 1 | 2016-07-01 13:47:32 | 1 | Bus |
| 2330 | 1915 | 1 | 2016-07-01 13:47:37 | 1 | Bus |
| 2331 | 1922 | 1 | 2016-07-01 13:47:38 | 1 | Bus |
| 2332 | 1917 | 1 | 2016-07-01 13:48:28 | 1 | Bus |
| 2333 | 1916 | 1 | 2016-07-01 13:48:38 | 1 | Bus |
| 2334 | 1926 | 1 | 2016-07-01 13:48:52 | 1 | Bus |
| 2335 | 1946 | 1 | 2016-07-01 13:48:56 | 1 | Bus |
| 2336 | 1938 | 1 | 2016-07-01 13:49:32 | 1 | Bus |
| 2337 | 1928 | 1 | 2016-07-01 13:49:50 | 1 | Bus |
| 2338 | 1942 | 1 | 2016-07-01 13:50:08 | 1 | Bus |
| 2339 | 1927 | 1 | 2016-07-01 13:50:13 | 1 | Bus |
| 2340 | 1924 | 1 | 2016-07-01 13:50:38 | 1 | Bus |
| 2341 | 1940 | 1 | 2016-07-01 13:50:38 | 1 | Bus |
| 2342 | 1930 | 1 | 2016-07-01 13:50:52 | 1 | Bus |
| 2343 | 1939 | 1 | 2016-07-01 13:51:15 | 1 | Bus |
| 2344 | 1944 | 1 | 2016-07-01 13:51:18 | 1 | Bus |
| 2345 | 1934 | 1 | 2016-07-01 13:51:44 | 1 | Bus |
| 2346 | 1945 | 1 | 2016-07-01 13:52:21 | 1 | Bus |
| 2347 | 1933 | 1 | 2016-07-01 13:52:53 | 1 | Bus |
| 2348 | 1935 | 1 | 2016-07-01 13:53:23 | 1 | Bus |
| 2349 | 1943 | 1 | 2016-07-01 13:53:41 | 1 | Bus |
| 2350 | 1947 | 1 | 2016-07-01 13:55:28 | 1 | Bus |
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;