Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 4,776–4,800 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 4776 | 4717 | 1 | 2017-11-22 12:13:14 | 1 | Walk |
| 4777 | 4737 | 1 | 2017-11-22 12:13:17 | 1 | Walk |
| 4778 | 4725 | 1 | 2017-11-22 12:13:19 | 1 | Walk |
| 4779 | 4710 | 1 | 2017-11-22 12:13:25 | 1 | Walk |
| 4780 | 4718 | 1 | 2017-11-22 12:13:25 | 1 | Walk |
| 4781 | 4714 | 1 | 2017-11-22 12:14:25 | 1 | Walk |
| 4782 | 4733 | 1 | 2017-11-22 12:14:55 | 1 | Walk |
| 4783 | 4724 | 1 | 2017-11-22 12:16:40 | 1 | Walk |
| 4784 | 4739 | 1 | 2017-11-22 12:16:43 | 1 | Walk |
| 4785 | 4732 | 1 | 2017-11-22 12:18:10 | 1 | Walk |
| 4786 | 4736 | 1 | 2017-11-22 12:19:10 | 1 | Walk |
| 4787 | 4741 | 1 | 2017-11-22 12:19:35 | 1 | Walk |
| 4788 | 4738 | 1 | 2017-11-22 12:19:40 | 1 | Walk |
| 4789 | 4835 | 1 | 2017-11-22 14:24:02 | 1 | Metro |
| 4790 | 4836 | 1 | 2017-11-22 14:24:02 | 1 | Metro |
| 4791 | 4883 | 2 | 2017-11-23 12:21:19 | 1 | Walk |
| 4792 | 4881 | 2 | 2017-11-23 12:21:53 | 1 | Walk |
| 4793 | 4884 | 2 | 2017-11-23 12:21:53 | 1 | Walk |
| 4794 | 4882 | 2 | 2017-11-23 12:21:57 | 1 | Walk |
| 4795 | 4866 | 4 | 2017-11-23 14:12:09 | 1 | Walk |
| 4796 | 4886 | 2 | 2017-11-23 14:39:32 | 1 | Metro |
| 4797 | 4885 | 2 | 2017-11-23 14:39:41 | 1 | Metro |
| 4798 | 4887 | 1 | 2017-11-23 16:28:25 | 1 | Bus |
| 4799 | 4891 | 2 | 2017-11-25 12:47:21 | 1 | Metro |
| 4800 | 4890 | 2 | 2017-11-25 12:47:28 | 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;