Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 676–700 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 676 | 849 | 1 | 2015-07-24 10:33:23 | 1 | Metro |
| 677 | 848 | 1 | 2015-07-24 10:33:24 | 1 | Metro |
| 678 | 842 | 1 | 2015-07-24 11:22:42 | 1 | Walk |
| 679 | 844 | 1 | 2015-07-24 11:22:54 | 1 | Walk |
| 680 | 840 | 1 | 2015-07-24 11:23:03 | 1 | Walk |
| 681 | 843 | 1 | 2015-07-24 11:23:07 | 1 | Walk |
| 682 | 841 | 1 | 2015-07-24 11:23:13 | 1 | Walk |
| 683 | 855 | 1 | 2015-07-25 10:22:53 | 1 | Walk |
| 684 | 854 | 1 | 2015-07-25 10:22:56 | 1 | Walk |
| 685 | 852 | 1 | 2015-07-25 10:22:57 | 1 | Walk |
| 686 | 856 | 1 | 2015-07-25 10:23:00 | 1 | Walk |
| 687 | 853 | 1 | 2015-07-25 10:23:06 | 1 | Walk |
| 688 | 814 | 2 | 2015-07-25 13:58:41 | 1 | Train |
| 689 | 857 | 1 | 2015-07-25 14:54:54 | 1 | Other |
| 690 | 858 | 2 | 2015-07-25 15:14:18 | 1 | Metro |
| 691 | 864 | 3 | 2015-07-26 09:24:38 | 1 | Metro |
| 692 | 863 | 3 | 2015-07-26 09:24:42 | 1 | Metro |
| 693 | 861 | 3 | 2015-07-26 09:24:43 | 1 | Metro |
| 694 | 862 | 3 | 2015-07-26 09:25:03 | 1 | Metro |
| 695 | 764 | 2 | 2015-07-26 12:25:10 | 1 | Walk |
| 696 | 765 | 2 | 2015-07-26 12:25:30 | 1 | Walk |
| 697 | 825 | 2 | 2015-07-27 15:10:40 | 1 | Bus |
| 698 | 878 | 3 | 2015-07-29 09:23:38 | 1 | Metro |
| 699 | 879 | 3 | 2015-07-29 09:23:52 | 1 | Metro |
| 700 | 877 | 3 | 2015-07-29 09:24:03 | 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;