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,701–1,725 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 1701 | 1745 | 2 | 2016-02-27 11:40:05 | 1 | Private Vehicle |
| 1702 | 1833 | 1 | 2016-02-27 13:24:31 | 1 | Metro |
| 1703 | 1834 | 1 | 2016-02-27 13:24:33 | 1 | Metro |
| 1704 | 1835 | 1 | 2016-02-27 13:24:38 | 1 | Metro |
| 1705 | 1836 | 1 | 2016-02-27 13:24:44 | 1 | Metro |
| 1706 | 1832 | 1 | 2016-02-27 13:25:03 | 1 | Metro |
| 1707 | 1842 | 4 | 2016-02-29 13:57:57 | 1 | Walk |
| 1708 | 1841 | 4 | 2016-02-29 13:58:17 | 1 | Walk |
| 1709 | 1840 | 4 | 2016-02-29 13:58:29 | 1 | Walk |
| 1710 | 1843 | 4 | 2016-02-29 13:58:44 | 1 | Walk |
| 1711 | 1849 | 1 | 2016-03-02 09:49:37 | 1 | Walk |
| 1712 | 1846 | 1 | 2016-03-02 09:49:44 | 1 | Walk |
| 1713 | 1848 | 1 | 2016-03-02 09:49:51 | 1 | Walk |
| 1714 | 1847 | 1 | 2016-03-02 09:50:12 | 1 | Walk |
| 1715 | 1851 | 1 | 2016-03-02 16:48:17 | 1 | Metro |
| 1716 | 1850 | 1 | 2016-03-02 16:48:29 | 1 | Metro |
| 1717 | 1462 | 1 | 2016-03-03 10:34:19 | 1 | Bus |
| 1718 | 1463 | 1 | 2016-03-03 10:34:32 | 1 | Bus |
| 1719 | 1464 | 1 | 2016-03-03 10:34:37 | 1 | Bus |
| 1720 | 1465 | 1 | 2016-03-03 10:34:49 | 1 | Bus |
| 1721 | 1467 | 1 | 2016-03-03 10:35:04 | 1 | Bus |
| 1722 | 1466 | 1 | 2016-03-03 10:35:07 | 1 | Bus |
| 1723 | 1469 | 1 | 2016-03-03 10:35:08 | 1 | Bus |
| 1724 | 1468 | 1 | 2016-03-03 10:35:31 | 1 | Bus |
| 1725 | 1470 | 1 | 2016-03-03 10:35:31 | 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;