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,551–2,575 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 2551 | 2636 | 1 | 2016-08-14 09:01:47 | 1 | Private Vehicle |
| 2552 | 2638 | 1 | 2016-08-14 09:01:54 | 1 | Private Vehicle |
| 2553 | 2639 | 4 | 2016-08-14 11:05:32 | 1 | Walk |
| 2554 | 2642 | 4 | 2016-08-14 11:05:36 | 1 | Walk |
| 2555 | 2641 | 4 | 2016-08-14 11:05:39 | 1 | Walk |
| 2556 | 2640 | 4 | 2016-08-14 11:05:50 | 1 | Walk |
| 2557 | 2590 | 1 | 2016-08-14 14:26:45 | 1 | Metro |
| 2558 | 2591 | 1 | 2016-08-14 14:26:49 | 1 | Metro |
| 2559 | 2589 | 1 | 2016-08-14 14:27:22 | 1 | Metro |
| 2560 | 2589 | 4 | 2016-08-14 16:00:56 | 0 | NULL |
| 2561 | 2591 | 1 | 2016-08-14 16:32:36 | 0 | NULL |
| 2562 | 2590 | 1 | 2016-08-14 17:08:58 | 0 | NULL |
| 2563 | 2645 | 2 | 2016-08-15 13:51:56 | 1 | Metro |
| 2564 | 2646 | 2 | 2016-08-15 13:52:07 | 1 | Metro |
| 2565 | 2647 | 2 | 2016-08-15 13:52:10 | 1 | Metro |
| 2566 | 2643 | 2 | 2016-08-15 13:52:12 | 1 | Metro |
| 2567 | 2644 | 2 | 2016-08-15 13:52:12 | 1 | Metro |
| 2568 | 2652 | 1 | 2016-08-16 11:56:58 | 1 | Train |
| 2569 | 2651 | 1 | 2016-08-16 11:57:04 | 1 | Train |
| 2570 | 2648 | 1 | 2016-08-16 11:57:15 | 1 | Train |
| 2571 | 2649 | 1 | 2016-08-16 11:57:15 | 1 | Train |
| 2572 | 2650 | 1 | 2016-08-16 11:57:24 | 1 | Train |
| 2573 | 2664 | 4 | 2016-08-18 11:00:05 | 1 | Walk |
| 2574 | 2582 | 2 | 2016-08-19 14:38:18 | 1 | Walk |
| 2575 | 2581 | 2 | 2016-08-19 14:38:24 | 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;