Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 1,676–1,700 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 1676 | 1812 | 1 | 2016-02-18 11:46:18 | 1 | Train |
| 1677 | 1814 | 1 | 2016-02-18 11:46:18 | 1 | Train |
| 1678 | 1778 | 1 | 2016-02-18 13:26:56 | 1 | Metro |
| 1679 | 1818 | 1 | 2016-02-18 15:32:03 | 1 | Other |
| 1680 | 1817 | 1 | 2016-02-18 15:32:25 | 1 | Other |
| 1681 | 1819 | 1 | 2016-02-18 15:32:37 | 1 | Other |
| 1682 | 1816 | 1 | 2016-02-18 15:32:45 | 1 | Other |
| 1683 | 1778 | 1 | 2016-02-18 17:25:52 | 0 | NULL |
| 1684 | 1822 | 1 | 2016-02-19 10:36:34 | 1 | Walk |
| 1685 | 1820 | 1 | 2016-02-19 10:36:42 | 1 | Walk |
| 1686 | 1821 | 1 | 2016-02-19 10:36:47 | 1 | Walk |
| 1687 | 1825 | 1 | 2016-02-19 16:47:42 | 1 | Metro |
| 1688 | 1826 | 5 | 2016-02-20 11:46:13 | 1 | Metro |
| 1689 | 1807 | 4 | 2016-02-22 12:12:22 | 1 | Other |
| 1690 | 1830 | 5 | 2016-02-23 10:45:42 | 1 | Walk |
| 1691 | 1829 | 5 | 2016-02-23 10:45:46 | 1 | Walk |
| 1692 | 1827 | 5 | 2016-02-23 10:45:53 | 1 | Walk |
| 1693 | 1828 | 5 | 2016-02-23 10:46:00 | 1 | Walk |
| 1694 | 1831 | 1 | 2016-02-25 13:35:18 | 1 | Walk |
| 1695 | 1831 | 3 | 2016-02-25 16:11:36 | 0 | NULL |
| 1696 | 1773 | 1 | 2016-02-26 10:53:32 | 1 | Bus |
| 1697 | 1744 | 2 | 2016-02-27 11:39:28 | 1 | Private Vehicle |
| 1698 | 1748 | 2 | 2016-02-27 11:39:54 | 1 | Private Vehicle |
| 1699 | 1747 | 2 | 2016-02-27 11:39:58 | 1 | Private Vehicle |
| 1700 | 1746 | 2 | 2016-02-27 11:39:59 | 1 | Private Vehicle |
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;