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,076–8,100 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 8076 | 7997 | 1 | 2019-05-31 11:54:39 | 1 | Bus |
| 8077 | 7998 | 1 | 2019-05-31 11:54:49 | 1 | Bus |
| 8078 | 8000 | 1 | 2019-05-31 11:54:57 | 1 | Bus |
| 8079 | 8001 | 1 | 2019-05-31 11:55:03 | 1 | Bus |
| 8080 | 7999 | 1 | 2019-05-31 11:55:09 | 1 | Bus |
| 8081 | 8002 | 1 | 2019-05-31 11:55:09 | 1 | Bus |
| 8082 | 8003 | 1 | 2019-05-31 11:55:15 | 1 | Bus |
| 8083 | 8006 | 1 | 2019-05-31 11:55:33 | 1 | Bus |
| 8084 | 8004 | 1 | 2019-05-31 11:55:35 | 1 | Bus |
| 8085 | 8005 | 1 | 2019-05-31 11:56:15 | 1 | Bus |
| 8086 | 8010 | 1 | 2019-05-31 11:56:36 | 1 | Bus |
| 8087 | 8014 | 1 | 2019-05-31 11:56:38 | 1 | Bus |
| 8088 | 8015 | 1 | 2019-05-31 11:56:45 | 1 | Bus |
| 8089 | 8024 | 1 | 2019-05-31 11:56:54 | 1 | Bus |
| 8090 | 8007 | 1 | 2019-05-31 11:56:59 | 1 | Bus |
| 8091 | 8025 | 1 | 2019-05-31 11:56:59 | 1 | Bus |
| 8092 | 8009 | 1 | 2019-05-31 11:57:03 | 1 | Bus |
| 8093 | 8011 | 1 | 2019-05-31 11:57:13 | 1 | Bus |
| 8094 | 8008 | 1 | 2019-05-31 11:57:24 | 1 | Bus |
| 8095 | 8016 | 1 | 2019-05-31 11:57:30 | 1 | Bus |
| 8096 | 8012 | 1 | 2019-05-31 11:57:39 | 1 | Bus |
| 8097 | 8013 | 1 | 2019-05-31 11:57:51 | 1 | Bus |
| 8098 | 8020 | 1 | 2019-05-31 11:58:06 | 1 | Bus |
| 8099 | 8027 | 1 | 2019-05-31 11:58:09 | 1 | Bus |
| 8100 | 8018 | 1 | 2019-05-31 11:58:51 | 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;