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,776–1,800 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 1776 | 1837 | 2 | 2016-03-10 11:09:40 | 1 | Metro |
| 1777 | 1868 | 3 | 2016-03-10 12:28:26 | 1 | Metro |
| 1778 | 1870 | 3 | 2016-03-10 12:28:29 | 1 | Metro |
| 1779 | 1869 | 3 | 2016-03-10 12:28:55 | 1 | Metro |
| 1780 | 1871 | 3 | 2016-03-10 12:28:57 | 1 | Metro |
| 1781 | 1889 | 2 | 2016-03-12 16:47:40 | 1 | Metro |
| 1782 | 1888 | 2 | 2016-03-12 16:47:43 | 1 | Metro |
| 1783 | 1891 | 2 | 2016-03-12 16:47:58 | 1 | Metro |
| 1784 | 1890 | 2 | 2016-03-12 16:48:05 | 1 | Metro |
| 1785 | 1857 | 1 | 2016-03-15 10:56:02 | 1 | Walk |
| 1786 | 1858 | 1 | 2016-03-15 10:56:27 | 1 | Walk |
| 1787 | 1856 | 1 | 2016-03-15 10:56:43 | 1 | Walk |
| 1788 | 1885 | 1 | 2016-03-16 11:33:59 | 1 | Walk |
| 1789 | 1883 | 1 | 2016-03-16 11:34:04 | 1 | Walk |
| 1790 | 1884 | 1 | 2016-03-16 11:34:06 | 1 | Walk |
| 1791 | 1882 | 1 | 2016-03-16 11:34:31 | 1 | Walk |
| 1792 | 1886 | 5 | 2016-03-16 11:56:44 | 1 | Walk |
| 1793 | 1875 | 1 | 2016-03-16 12:53:54 | 1 | Taxi |
| 1794 | 1876 | 1 | 2016-03-16 12:53:57 | 1 | Taxi |
| 1795 | 1874 | 1 | 2016-03-16 12:54:22 | 1 | Taxi |
| 1796 | 1873 | 1 | 2016-03-16 12:54:27 | 1 | Taxi |
| 1797 | 1877 | 1 | 2016-03-16 12:54:36 | 1 | Taxi |
| 1798 | 1959 | 1 | 2016-03-16 13:41:50 | 1 | Taxi |
| 1799 | 1964 | 5 | 2016-03-18 11:09:11 | 1 | Bus |
| 1800 | 1686 | 4 | 2016-03-18 12:38:32 | 1 | Bus |
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;