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,651–1,675 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 1651 | 1785 | 2 | 2016-02-09 13:41:56 | 1 | Metro |
| 1652 | 1787 | 4 | 2016-02-11 12:23:03 | 1 | Walk |
| 1653 | 1790 | 2 | 2016-02-13 11:08:51 | 1 | Metro |
| 1654 | 1789 | 2 | 2016-02-13 11:09:08 | 1 | Metro |
| 1655 | 1788 | 2 | 2016-02-13 11:09:18 | 1 | Metro |
| 1656 | 1796 | 1 | 2016-02-14 16:13:42 | 1 | Bus |
| 1657 | 1795 | 1 | 2016-02-14 16:13:52 | 1 | Bus |
| 1658 | 1797 | 1 | 2016-02-14 16:14:15 | 1 | Bus |
| 1659 | 1794 | 1 | 2016-02-14 16:14:31 | 1 | Bus |
| 1660 | 1801 | 1 | 2016-02-16 09:36:14 | 1 | Walk |
| 1661 | 1800 | 1 | 2016-02-16 09:36:16 | 1 | Walk |
| 1662 | 1799 | 1 | 2016-02-16 09:36:31 | 1 | Walk |
| 1663 | 1803 | 4 | 2016-02-16 16:43:33 | 1 | Walk |
| 1664 | 1804 | 4 | 2016-02-16 16:43:34 | 1 | Walk |
| 1665 | 1805 | 4 | 2016-02-16 16:43:48 | 1 | Walk |
| 1666 | 1802 | 4 | 2016-02-16 16:44:03 | 1 | Walk |
| 1667 | 1806 | 4 | 2016-02-16 16:44:03 | 1 | Walk |
| 1668 | 1791 | 1 | 2016-02-17 11:40:34 | 1 | Metro |
| 1669 | 1792 | 1 | 2016-02-17 11:40:51 | 1 | Metro |
| 1670 | 1793 | 1 | 2016-02-17 11:41:01 | 1 | Metro |
| 1671 | 1810 | 1 | 2016-02-17 15:59:00 | 1 | Taxi |
| 1672 | 1809 | 1 | 2016-02-17 15:59:19 | 1 | Taxi |
| 1673 | 1811 | 1 | 2016-02-17 15:59:43 | 1 | Taxi |
| 1674 | 1815 | 1 | 2016-02-18 11:46:10 | 1 | Train |
| 1675 | 1813 | 1 | 2016-02-18 11:46:13 | 1 | Train |
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;