Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 226–250 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 226 | 313 | 2 | 2015-04-26 09:06:32 | 1 | Private Vehicle |
| 227 | 312 | 2 | 2015-04-26 09:06:40 | 1 | Private Vehicle |
| 228 | 261 | 1 | 2015-04-26 09:12:15 | 1 | Metro |
| 229 | 260 | 1 | 2015-04-26 09:12:18 | 1 | Metro |
| 230 | 307 | 2 | 2015-04-26 10:54:18 | 1 | Private Vehicle |
| 231 | 306 | 2 | 2015-04-26 10:54:27 | 1 | Private Vehicle |
| 232 | 291 | 2 | 2015-04-26 11:17:26 | 1 | Private Vehicle |
| 233 | 327 | 2 | 2015-04-26 12:02:45 | 1 | Metro |
| 234 | 303 | 2 | 2015-04-26 12:54:14 | 1 | Bus |
| 235 | 304 | 2 | 2015-04-26 12:54:42 | 1 | Bus |
| 236 | 302 | 2 | 2015-04-26 12:54:52 | 1 | Bus |
| 237 | 331 | 1 | 2015-04-26 13:23:59 | 1 | Walk |
| 238 | 228 | 2 | 2015-04-27 11:00:14 | 1 | Metro |
| 239 | 227 | 2 | 2015-04-27 11:00:47 | 1 | Metro |
| 240 | 296 | 4 | 2015-04-27 11:04:41 | 1 | Bus |
| 241 | 297 | 4 | 2015-04-27 11:04:44 | 1 | Bus |
| 242 | 342 | 2 | 2015-04-29 11:23:28 | 1 | Metro |
| 243 | 341 | 2 | 2015-04-29 11:23:44 | 1 | Metro |
| 244 | 348 | 1 | 2015-04-29 12:10:24 | 1 | Bus |
| 245 | 355 | 1 | 2015-04-30 16:11:36 | 1 | Other |
| 246 | 354 | 1 | 2015-04-30 16:12:05 | 1 | Other |
| 247 | 360 | 1 | 2015-05-01 10:12:06 | 1 | Train |
| 248 | 359 | 1 | 2015-05-01 10:12:23 | 1 | Train |
| 249 | 358 | 1 | 2015-05-01 10:12:29 | 1 | Train |
| 250 | 420 | 1 | 2015-05-01 11:29:53 | 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;