Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 651–675 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 651 | 824 | 5 | 2015-07-21 11:49:44 | 1 | Other |
| 652 | 821 | 4 | 2015-07-21 11:50:27 | 1 | Taxi |
| 653 | 822 | 4 | 2015-07-21 11:50:31 | 1 | Taxi |
| 654 | 823 | 5 | 2015-07-21 13:46:44 | 0 | NULL |
| 655 | 824 | 5 | 2015-07-21 14:40:53 | 0 | NULL |
| 656 | 826 | 1 | 2015-07-22 11:46:15 | 1 | Metro |
| 657 | 827 | 2 | 2015-07-22 12:03:24 | 1 | Metro |
| 658 | 793 | 1 | 2015-07-22 12:25:13 | 1 | Walk |
| 659 | 792 | 1 | 2015-07-22 12:25:41 | 1 | Walk |
| 660 | 791 | 1 | 2015-07-22 12:25:51 | 1 | Walk |
| 661 | 829 | 1 | 2015-07-22 12:33:20 | 1 | Walk |
| 662 | 828 | 1 | 2015-07-22 12:33:35 | 1 | Walk |
| 663 | 830 | 5 | 2015-07-22 12:56:24 | 1 | Metro |
| 664 | 831 | 5 | 2015-07-22 12:56:53 | 1 | Metro |
| 665 | 813 | 4 | 2015-07-23 09:10:36 | 1 | Taxi |
| 666 | 812 | 4 | 2015-07-23 09:10:55 | 1 | Taxi |
| 667 | 805 | 3 | 2015-07-23 10:28:21 | 1 | Walk |
| 668 | 833 | 1 | 2015-07-23 11:17:39 | 1 | Other |
| 669 | 832 | 2 | 2015-07-23 11:22:14 | 1 | Metro |
| 670 | 805 | 3 | 2015-07-23 12:08:02 | 0 | NULL |
| 671 | 834 | 2 | 2015-07-23 13:00:35 | 1 | Bus |
| 672 | 835 | 3 | 2015-07-23 14:18:30 | 1 | Walk |
| 673 | 846 | 3 | 2015-07-24 09:01:17 | 1 | Metro |
| 674 | 845 | 3 | 2015-07-24 09:01:21 | 1 | Metro |
| 675 | 847 | 1 | 2015-07-24 09:32:10 | 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;