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,376–2,400 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 2376 | 2448 | 5 | 2016-07-10 13:24:02 | 1 | Walk |
| 2377 | 2463 | 1 | 2016-07-11 10:49:48 | 1 | Walk |
| 2378 | 2464 | 1 | 2016-07-11 10:50:05 | 1 | Walk |
| 2379 | 2469 | 2 | 2016-07-11 11:14:18 | 1 | Walk |
| 2380 | 2470 | 2 | 2016-07-11 11:14:24 | 1 | Walk |
| 2381 | 2467 | 1 | 2016-07-11 11:18:10 | 1 | Walk |
| 2382 | 2465 | 1 | 2016-07-11 11:18:20 | 1 | Walk |
| 2383 | 2466 | 1 | 2016-07-11 11:18:45 | 1 | Walk |
| 2384 | 2468 | 1 | 2016-07-11 11:18:49 | 1 | Walk |
| 2385 | 2472 | 5 | 2016-07-11 14:20:59 | 1 | Bus |
| 2386 | 2471 | 5 | 2016-07-11 14:21:05 | 1 | Bus |
| 2387 | 2424 | 2 | 2016-07-12 09:03:07 | 1 | Walk |
| 2388 | 2474 | 1 | 2016-07-12 11:56:50 | 1 | Walk |
| 2389 | 2475 | 1 | 2016-07-12 11:56:59 | 1 | Walk |
| 2390 | 2427 | 2 | 2016-07-12 12:08:01 | 1 | Private Vehicle |
| 2391 | 2428 | 2 | 2016-07-12 12:08:01 | 1 | Private Vehicle |
| 2392 | 2425 | 2 | 2016-07-12 12:08:04 | 1 | Private Vehicle |
| 2393 | 2426 | 2 | 2016-07-12 12:08:33 | 1 | Private Vehicle |
| 2394 | 2473 | 4 | 2016-07-12 13:49:04 | 1 | Bus |
| 2395 | 2485 | 1 | 2016-07-14 10:15:14 | 1 | Metro |
| 2396 | 2484 | 1 | 2016-07-14 10:15:41 | 1 | Metro |
| 2397 | 2487 | 3 | 2016-07-14 16:11:16 | 1 | Metro |
| 2398 | 2486 | 3 | 2016-07-14 16:11:20 | 1 | Metro |
| 2399 | 2488 | 3 | 2016-07-14 16:11:26 | 1 | Metro |
| 2400 | 2489 | 1 | 2016-07-15 09:44:42 | 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;