Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 9,601–9,625 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 9601 | 9715 | 1 | 2020-01-22 13:17:13 | 1 | Walk |
| 9602 | 9713 | 2 | 2020-01-22 14:25:48 | 1 | Metro |
| 9603 | 9712 | 2 | 2020-01-22 14:26:06 | 1 | Metro |
| 9604 | 9717 | 1 | 2020-01-23 12:44:08 | 1 | Walk |
| 9605 | 9720 | 1 | 2020-01-23 12:44:09 | 1 | Walk |
| 9606 | 9719 | 1 | 2020-01-23 12:44:43 | 1 | Walk |
| 9607 | 9665 | 2 | 2020-01-23 13:22:11 | 1 | Metro |
| 9608 | 9664 | 2 | 2020-01-23 13:22:50 | 1 | Metro |
| 9609 | 9722 | 1 | 2020-01-23 14:25:28 | 1 | Bus |
| 9610 | 9721 | 1 | 2020-01-23 14:25:40 | 1 | Bus |
| 9611 | 9732 | 2 | 2020-01-25 09:02:58 | 1 | Taxi |
| 9612 | 9733 | 2 | 2020-01-25 09:03:08 | 1 | Taxi |
| 9613 | 9730 | 2 | 2020-01-25 14:23:22 | 1 | Taxi |
| 9614 | 9726 | 2 | 2020-01-25 14:23:28 | 1 | Taxi |
| 9615 | 9729 | 2 | 2020-01-25 14:23:39 | 1 | Taxi |
| 9616 | 9727 | 2 | 2020-01-25 14:23:41 | 1 | Taxi |
| 9617 | 9728 | 2 | 2020-01-25 14:23:49 | 1 | Taxi |
| 9618 | 9736 | 3 | 2020-01-26 12:14:57 | 1 | Bus |
| 9619 | 9740 | 5 | 2020-01-27 09:07:00 | 1 | Walk |
| 9620 | 9745 | 2 | 2020-01-29 11:00:13 | 1 | Taxi |
| 9621 | 9725 | 1 | 2020-01-29 11:10:25 | 1 | Walk |
| 9622 | 9724 | 1 | 2020-01-29 11:10:47 | 1 | Walk |
| 9623 | 9723 | 1 | 2020-01-29 11:11:09 | 1 | Walk |
| 9624 | 9737 | 1 | 2020-01-29 13:01:08 | 1 | Other |
| 9625 | 9739 | 1 | 2020-01-29 13:01:14 | 1 | Other |
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;