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,401–2,425 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 2401 | 2495 | 1 | 2016-07-15 10:01:06 | 1 | Walk |
| 2402 | 2496 | 1 | 2016-07-15 10:01:15 | 1 | Walk |
| 2403 | 2494 | 1 | 2016-07-15 10:11:08 | 1 | Metro |
| 2404 | 2493 | 1 | 2016-07-15 10:11:24 | 1 | Metro |
| 2405 | 2455 | 1 | 2016-07-15 10:14:12 | 1 | Bus |
| 2406 | 2456 | 1 | 2016-07-15 10:14:22 | 1 | Bus |
| 2407 | 2454 | 1 | 2016-07-15 10:14:29 | 1 | Bus |
| 2408 | 2447 | 1 | 2016-07-15 10:40:51 | 1 | Metro |
| 2409 | 2481 | 1 | 2016-07-15 14:48:25 | 1 | Taxi |
| 2410 | 2480 | 1 | 2016-07-15 14:48:27 | 1 | Taxi |
| 2411 | 2499 | 2 | 2016-07-16 09:13:42 | 1 | Bus |
| 2412 | 2498 | 2 | 2016-07-16 09:14:01 | 1 | Bus |
| 2413 | 2500 | 2 | 2016-07-16 09:14:03 | 1 | Bus |
| 2414 | 2497 | 2 | 2016-07-16 09:14:06 | 1 | Bus |
| 2415 | 2501 | 2 | 2016-07-16 09:14:08 | 1 | Bus |
| 2416 | 2492 | 4 | 2016-07-16 10:17:14 | 1 | Walk |
| 2417 | 2490 | 4 | 2016-07-16 10:17:44 | 1 | Walk |
| 2418 | 2506 | 2 | 2016-07-16 14:07:11 | 1 | Metro |
| 2419 | 2508 | 2 | 2016-07-16 14:07:17 | 1 | Metro |
| 2420 | 2504 | 2 | 2016-07-16 14:07:21 | 1 | Metro |
| 2421 | 2505 | 2 | 2016-07-16 14:07:24 | 1 | Metro |
| 2422 | 2507 | 2 | 2016-07-16 14:07:46 | 1 | Metro |
| 2423 | 2502 | 4 | 2016-07-16 14:30:12 | 1 | Walk |
| 2424 | 2503 | 4 | 2016-07-16 14:30:36 | 1 | Walk |
| 2425 | 2482 | 1 | 2016-07-17 10:00:15 | 1 | Walk |
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;