Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 3,676–3,700 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 3676 | 3429 | 4 | 2017-05-03 11:58:55 | 1 | Bus |
| 3677 | 3431 | 4 | 2017-05-03 11:59:00 | 1 | Bus |
| 3678 | 3435 | 4 | 2017-05-03 11:59:01 | 1 | Bus |
| 3679 | 3432 | 4 | 2017-05-03 11:59:13 | 1 | Bus |
| 3680 | 3437 | 4 | 2017-05-03 11:59:15 | 1 | Bus |
| 3681 | 3430 | 4 | 2017-05-03 11:59:25 | 1 | Bus |
| 3682 | 3449 | 4 | 2017-05-03 11:59:33 | 1 | Bus |
| 3683 | 3434 | 4 | 2017-05-03 11:59:45 | 1 | Bus |
| 3684 | 3443 | 4 | 2017-05-03 11:59:49 | 1 | Bus |
| 3685 | 3454 | 4 | 2017-05-03 11:59:49 | 1 | Bus |
| 3686 | 3433 | 4 | 2017-05-03 12:00:03 | 1 | Bus |
| 3687 | 3458 | 4 | 2017-05-03 12:00:05 | 1 | Bus |
| 3688 | 3445 | 4 | 2017-05-03 12:00:10 | 1 | Bus |
| 3689 | 3440 | 4 | 2017-05-03 12:00:22 | 1 | Bus |
| 3690 | 3457 | 4 | 2017-05-03 12:00:25 | 1 | Bus |
| 3691 | 3456 | 4 | 2017-05-03 12:00:43 | 1 | Bus |
| 3692 | 3438 | 4 | 2017-05-03 12:00:48 | 1 | Bus |
| 3693 | 3439 | 4 | 2017-05-03 12:01:01 | 1 | Bus |
| 3694 | 3469 | 4 | 2017-05-03 12:01:10 | 1 | Bus |
| 3695 | 3446 | 4 | 2017-05-03 12:01:21 | 1 | Bus |
| 3696 | 3459 | 4 | 2017-05-03 12:01:53 | 1 | Bus |
| 3697 | 3452 | 4 | 2017-05-03 12:02:05 | 1 | Bus |
| 3698 | 3455 | 4 | 2017-05-03 12:02:27 | 1 | Bus |
| 3699 | 3451 | 4 | 2017-05-03 12:02:51 | 1 | Bus |
| 3700 | 3450 | 4 | 2017-05-03 12:02:55 | 1 | Bus |
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;