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,576–1,600 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 1576 | 1681 | 3 | 2016-01-05 11:04:46 | 1 | Metro |
| 1577 | 1682 | 3 | 2016-01-05 11:04:52 | 1 | Metro |
| 1578 | 1677 | 1 | 2016-01-05 16:19:05 | 1 | Walk |
| 1579 | 1675 | 1 | 2016-01-05 16:19:27 | 1 | Walk |
| 1580 | 1674 | 1 | 2016-01-05 16:19:32 | 1 | Walk |
| 1581 | 1676 | 1 | 2016-01-05 16:19:32 | 1 | Walk |
| 1582 | 1684 | 4 | 2016-01-06 10:15:24 | 1 | Metro |
| 1583 | 1651 | 1 | 2016-01-06 11:00:13 | 1 | Metro |
| 1584 | 1634 | 2 | 2016-01-07 11:45:29 | 1 | Bus |
| 1585 | 1685 | 2 | 2016-01-09 14:54:44 | 1 | Taxi |
| 1586 | 1732 | 2 | 2016-01-10 12:20:17 | 1 | Metro |
| 1587 | 1678 | 4 | 2016-01-11 11:32:48 | 1 | Walk |
| 1588 | 1679 | 4 | 2016-01-11 11:32:54 | 1 | Walk |
| 1589 | 1680 | 4 | 2016-01-11 11:33:04 | 1 | Walk |
| 1590 | 1733 | 4 | 2016-01-12 11:10:04 | 1 | Bus |
| 1591 | 1734 | 4 | 2016-01-12 11:10:24 | 1 | Bus |
| 1592 | 1664 | 3 | 2016-01-12 11:43:36 | 1 | Walk |
| 1593 | 1661 | 3 | 2016-01-12 11:43:41 | 1 | Walk |
| 1594 | 1663 | 3 | 2016-01-12 11:43:43 | 1 | Walk |
| 1595 | 1660 | 3 | 2016-01-12 11:43:50 | 1 | Walk |
| 1596 | 1662 | 3 | 2016-01-12 11:43:59 | 1 | Walk |
| 1597 | 1665 | 2 | 2016-01-13 16:02:12 | 1 | Private Vehicle |
| 1598 | 1666 | 2 | 2016-01-13 16:02:19 | 1 | Private Vehicle |
| 1599 | 1608 | 1 | 2016-01-15 15:01:50 | 1 | Metro |
| 1600 | 1609 | 1 | 2016-01-15 15:02:18 | 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;