Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 7,426–7,450 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 7426 | 7138 | 4 | 2019-02-27 12:58:34 | 1 | Metro |
| 7427 | 7144 | 4 | 2019-02-27 13:00:51 | 1 | Metro |
| 7428 | 7622 | 4 | 2019-02-28 11:33:22 | 1 | Taxi |
| 7429 | 7623 | 4 | 2019-02-28 11:33:41 | 1 | Taxi |
| 7430 | 7608 | 1 | 2019-02-28 14:37:59 | 1 | Walk |
| 7431 | 7609 | 1 | 2019-02-28 14:38:02 | 1 | Walk |
| 7432 | 7607 | 1 | 2019-02-28 14:38:09 | 1 | Walk |
| 7433 | 7606 | 1 | 2019-02-28 14:38:44 | 1 | Walk |
| 7434 | 7736 | 1 | 2019-03-01 11:01:54 | 1 | Private Vehicle |
| 7435 | 7737 | 1 | 2019-03-01 11:01:56 | 1 | Private Vehicle |
| 7436 | 7738 | 1 | 2019-03-01 11:02:06 | 1 | Private Vehicle |
| 7437 | 7743 | 5 | 2019-03-02 10:38:45 | 1 | Bus |
| 7438 | 7745 | 5 | 2019-03-02 10:38:46 | 1 | Bus |
| 7439 | 7741 | 5 | 2019-03-02 10:38:58 | 1 | Bus |
| 7440 | 7742 | 5 | 2019-03-02 10:39:00 | 1 | Bus |
| 7441 | 7744 | 5 | 2019-03-02 10:39:05 | 1 | Bus |
| 7442 | 7717 | 1 | 2019-03-03 12:38:50 | 1 | Walk |
| 7443 | 7716 | 1 | 2019-03-03 12:39:07 | 1 | Walk |
| 7444 | 7756 | 2 | 2019-03-04 10:29:35 | 1 | Bus |
| 7445 | 7755 | 2 | 2019-03-04 10:29:50 | 1 | Bus |
| 7446 | 7754 | 2 | 2019-03-04 10:29:51 | 1 | Bus |
| 7447 | 7762 | 1 | 2019-03-05 09:36:23 | 1 | Walk |
| 7448 | 7765 | 1 | 2019-03-05 09:36:28 | 1 | Walk |
| 7449 | 7764 | 1 | 2019-03-05 09:36:58 | 1 | Walk |
| 7450 | 7751 | 5 | 2019-03-05 11:24:56 | 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;