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,226–5,250 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 5226 | 5178 | 1 | 2018-03-23 12:02:57 | 1 | Metro |
| 5227 | 5186 | 1 | 2018-03-23 12:03:02 | 1 | Metro |
| 5228 | 5176 | 1 | 2018-03-23 12:03:08 | 1 | Metro |
| 5229 | 5161 | 1 | 2018-03-23 12:03:12 | 1 | Metro |
| 5230 | 5169 | 1 | 2018-03-23 12:03:17 | 1 | Metro |
| 5231 | 5191 | 1 | 2018-03-23 12:03:18 | 1 | Metro |
| 5232 | 5165 | 1 | 2018-03-23 12:03:25 | 1 | Metro |
| 5233 | 5194 | 1 | 2018-03-23 12:03:30 | 1 | Metro |
| 5234 | 5168 | 1 | 2018-03-23 12:03:36 | 1 | Metro |
| 5235 | 5197 | 1 | 2018-03-23 12:03:38 | 1 | Metro |
| 5236 | 5175 | 1 | 2018-03-23 12:03:42 | 1 | Metro |
| 5237 | 5174 | 1 | 2018-03-23 12:03:53 | 1 | Metro |
| 5238 | 5172 | 1 | 2018-03-23 12:04:20 | 1 | Metro |
| 5239 | 5180 | 1 | 2018-03-23 12:04:22 | 1 | Metro |
| 5240 | 5182 | 1 | 2018-03-23 12:04:30 | 1 | Metro |
| 5241 | 5183 | 1 | 2018-03-23 12:04:38 | 1 | Metro |
| 5242 | 5188 | 1 | 2018-03-23 12:04:39 | 1 | Metro |
| 5243 | 5170 | 1 | 2018-03-23 12:04:46 | 1 | Metro |
| 5244 | 5196 | 1 | 2018-03-23 12:04:50 | 1 | Metro |
| 5245 | 5190 | 1 | 2018-03-23 12:04:53 | 1 | Metro |
| 5246 | 5192 | 1 | 2018-03-23 12:05:07 | 1 | Metro |
| 5247 | 5184 | 1 | 2018-03-23 12:05:14 | 1 | Metro |
| 5248 | 5189 | 1 | 2018-03-23 12:05:18 | 1 | Metro |
| 5249 | 5177 | 1 | 2018-03-23 12:06:32 | 1 | Metro |
| 5250 | 5185 | 1 | 2018-03-23 12:07:19 | 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;