Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 8,651–8,675 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 8651 | 8594 | 5 | 2019-08-26 11:52:51 | 1 | Walk |
| 8652 | 8829 | 1 | 2019-08-26 14:03:38 | 1 | Metro |
| 8653 | 8830 | 1 | 2019-08-26 14:03:51 | 1 | Metro |
| 8654 | 8728 | 1 | 2019-08-26 15:50:41 | 1 | Private Vehicle |
| 8655 | 8727 | 1 | 2019-08-26 15:51:13 | 1 | Private Vehicle |
| 8656 | 8839 | 1 | 2019-08-27 10:14:57 | 1 | Walk |
| 8657 | 8836 | 1 | 2019-08-27 10:15:01 | 1 | Walk |
| 8658 | 8838 | 1 | 2019-08-27 10:15:03 | 1 | Walk |
| 8659 | 8835 | 1 | 2019-08-27 10:15:06 | 1 | Walk |
| 8660 | 8837 | 1 | 2019-08-27 10:15:20 | 1 | Walk |
| 8661 | 8711 | 4 | 2019-08-27 10:36:00 | 1 | Metro |
| 8662 | 8702 | 2 | 2019-08-27 16:09:57 | 1 | Train |
| 8663 | 8703 | 2 | 2019-08-27 16:10:00 | 1 | Train |
| 8664 | 8823 | 5 | 2019-08-28 09:28:34 | 1 | Bus |
| 8665 | 8822 | 5 | 2019-08-28 09:28:40 | 1 | Bus |
| 8666 | 8840 | 2 | 2019-08-28 10:27:29 | 1 | Walk |
| 8667 | 8842 | 2 | 2019-08-28 10:27:32 | 1 | Walk |
| 8668 | 8841 | 2 | 2019-08-28 10:27:35 | 1 | Walk |
| 8669 | 8843 | 2 | 2019-08-28 10:27:41 | 1 | Walk |
| 8670 | 8768 | 3 | 2019-08-28 10:54:37 | 1 | Metro |
| 8671 | 8767 | 3 | 2019-08-28 10:54:39 | 1 | Metro |
| 8672 | 8844 | 4 | 2019-08-28 11:01:57 | 1 | Bus |
| 8673 | 8802 | 1 | 2019-08-28 11:27:37 | 1 | Taxi |
| 8674 | 8804 | 1 | 2019-08-28 11:27:49 | 1 | Taxi |
| 8675 | 8801 | 1 | 2019-08-28 11:27:56 | 1 | Taxi |
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;