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,101–9,125 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 9101 | 9372 | 1 | 2019-11-08 13:43:34 | 1 | Walk |
| 9102 | 9371 | 1 | 2019-11-08 13:43:56 | 1 | Walk |
| 9103 | 9348 | 1 | 2019-11-08 15:33:28 | 1 | Walk |
| 9104 | 9349 | 1 | 2019-11-08 15:34:15 | 1 | Walk |
| 9105 | 9349 | 1 | 2019-11-08 17:15:56 | 0 | NULL |
| 9106 | 9348 | 1 | 2019-11-08 17:26:03 | 0 | NULL |
| 9107 | 9184 | 4 | 2019-11-09 11:29:55 | 1 | Bus |
| 9108 | 9185 | 4 | 2019-11-09 11:30:09 | 1 | Bus |
| 9109 | 9186 | 4 | 2019-11-09 11:30:13 | 1 | Bus |
| 9110 | 9187 | 4 | 2019-11-09 11:30:34 | 1 | Bus |
| 9111 | 9188 | 4 | 2019-11-09 11:30:35 | 1 | Bus |
| 9112 | 9193 | 4 | 2019-11-09 11:30:40 | 1 | Bus |
| 9113 | 9190 | 4 | 2019-11-09 11:30:43 | 1 | Bus |
| 9114 | 9194 | 4 | 2019-11-09 11:30:45 | 1 | Bus |
| 9115 | 9189 | 4 | 2019-11-09 11:30:50 | 1 | Bus |
| 9116 | 9201 | 4 | 2019-11-09 11:31:03 | 1 | Bus |
| 9117 | 9191 | 4 | 2019-11-09 11:31:05 | 1 | Bus |
| 9118 | 9198 | 4 | 2019-11-09 11:31:05 | 1 | Bus |
| 9119 | 9192 | 4 | 2019-11-09 11:31:15 | 1 | Bus |
| 9120 | 9203 | 4 | 2019-11-09 11:32:08 | 1 | Bus |
| 9121 | 9207 | 4 | 2019-11-09 11:32:13 | 1 | Bus |
| 9122 | 9195 | 4 | 2019-11-09 11:32:18 | 1 | Bus |
| 9123 | 9208 | 4 | 2019-11-09 11:32:19 | 1 | Bus |
| 9124 | 9199 | 4 | 2019-11-09 11:32:25 | 1 | Bus |
| 9125 | 9196 | 4 | 2019-11-09 11:32:31 | 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;