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,601–1,625 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 1601 | 1737 | 5 | 2016-01-16 13:25:17 | 1 | Walk |
| 1602 | 1741 | 1 | 2016-01-18 09:09:53 | 1 | Walk |
| 1603 | 1742 | 1 | 2016-01-18 09:09:54 | 1 | Walk |
| 1604 | 1735 | 3 | 2016-01-18 09:54:33 | 1 | Metro |
| 1605 | 1736 | 3 | 2016-01-18 09:54:38 | 1 | Metro |
| 1606 | 1621 | 1 | 2016-01-21 10:15:12 | 1 | Metro |
| 1607 | 1622 | 1 | 2016-01-21 10:15:24 | 1 | Metro |
| 1608 | 1750 | 1 | 2016-01-22 10:33:05 | 1 | Walk |
| 1609 | 1751 | 1 | 2016-01-22 10:33:24 | 1 | Walk |
| 1610 | 1754 | 2 | 2016-01-23 09:17:48 | 1 | Metro |
| 1611 | 1753 | 2 | 2016-01-23 09:18:06 | 1 | Metro |
| 1612 | 1752 | 2 | 2016-01-23 09:18:31 | 1 | Metro |
| 1613 | 1755 | 5 | 2016-01-23 09:32:11 | 1 | Metro |
| 1614 | 1756 | 5 | 2016-01-23 09:32:36 | 1 | Metro |
| 1615 | 1757 | 1 | 2016-01-23 11:18:23 | 1 | Walk |
| 1616 | 1758 | 1 | 2016-01-23 11:18:49 | 1 | Walk |
| 1617 | 1759 | 1 | 2016-01-23 11:59:39 | 1 | Taxi |
| 1618 | 1760 | 1 | 2016-01-23 11:59:53 | 1 | Taxi |
| 1619 | 1761 | 1 | 2016-01-23 12:00:11 | 1 | Taxi |
| 1620 | 1738 | 5 | 2016-01-24 09:47:03 | 1 | Walk |
| 1621 | 1740 | 5 | 2016-01-24 09:47:03 | 1 | Walk |
| 1622 | 1739 | 5 | 2016-01-24 09:47:25 | 1 | Walk |
| 1623 | 1762 | 1 | 2016-01-24 10:40:12 | 1 | Metro |
| 1624 | 1671 | 1 | 2016-01-24 13:56:11 | 1 | Walk |
| 1625 | 1669 | 1 | 2016-01-24 13:56:22 | 1 | Walk |
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;