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,626–1,650 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 1626 | 1668 | 1 | 2016-01-24 13:56:23 | 1 | Walk |
| 1627 | 1667 | 1 | 2016-01-24 13:56:25 | 1 | Walk |
| 1628 | 1670 | 1 | 2016-01-24 13:56:34 | 1 | Walk |
| 1629 | 1749 | 2 | 2016-01-25 15:19:23 | 1 | Walk |
| 1630 | 1764 | 2 | 2016-01-26 10:46:27 | 1 | Private Vehicle |
| 1631 | 1763 | 2 | 2016-01-26 10:46:33 | 1 | Private Vehicle |
| 1632 | 1767 | 1 | 2016-01-30 12:47:23 | 1 | Walk |
| 1633 | 1769 | 1 | 2016-01-30 12:47:43 | 1 | Walk |
| 1634 | 1768 | 1 | 2016-01-30 12:47:53 | 1 | Walk |
| 1635 | 1770 | 1 | 2016-01-30 16:47:42 | 1 | Other |
| 1636 | 1743 | 1 | 2016-01-31 10:11:00 | 1 | Train |
| 1637 | 1542 | 2 | 2016-01-31 15:30:06 | 1 | Private Vehicle |
| 1638 | 1541 | 2 | 2016-01-31 15:30:20 | 1 | Private Vehicle |
| 1639 | 1775 | 2 | 2016-02-02 09:44:55 | 1 | Metro |
| 1640 | 1777 | 4 | 2016-02-03 11:01:58 | 1 | Walk |
| 1641 | 1776 | 4 | 2016-02-03 11:02:14 | 1 | Walk |
| 1642 | 1772 | 1 | 2016-02-04 12:24:12 | 1 | Walk |
| 1643 | 1771 | 1 | 2016-02-04 12:24:48 | 1 | Walk |
| 1644 | 1779 | 4 | 2016-02-07 11:14:48 | 1 | Taxi |
| 1645 | 1780 | 4 | 2016-02-07 11:14:54 | 1 | Taxi |
| 1646 | 1781 | 3 | 2016-02-07 13:19:40 | 1 | Walk |
| 1647 | 1784 | 2 | 2016-02-09 12:25:28 | 1 | Taxi |
| 1648 | 1782 | 2 | 2016-02-09 12:25:54 | 1 | Taxi |
| 1649 | 1783 | 2 | 2016-02-09 12:26:09 | 1 | Taxi |
| 1650 | 1786 | 2 | 2016-02-09 13:41:54 | 1 | Metro |
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;