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,451–7,475 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 7451 | 7753 | 5 | 2019-03-05 11:25:20 | 1 | Walk |
| 7452 | 7752 | 5 | 2019-03-05 11:25:45 | 1 | Walk |
| 7453 | 7770 | 4 | 2019-03-05 11:29:56 | 1 | Metro |
| 7454 | 7769 | 4 | 2019-03-05 11:30:18 | 1 | Metro |
| 7455 | 7768 | 4 | 2019-03-05 11:30:28 | 1 | Metro |
| 7456 | 7752 | 5 | 2019-03-05 13:08:31 | 0 | NULL |
| 7457 | 7751 | 5 | 2019-03-05 14:25:32 | 0 | NULL |
| 7458 | 7753 | 1 | 2019-03-05 15:20:43 | 0 | NULL |
| 7459 | 7773 | 4 | 2019-03-06 09:48:42 | 1 | Bus |
| 7460 | 7659 | 3 | 2019-03-06 10:27:06 | 1 | Walk |
| 7461 | 7632 | 2 | 2019-03-06 11:09:35 | 1 | Walk |
| 7462 | 7632 | 2 | 2019-03-06 15:08:05 | 0 | NULL |
| 7463 | 7729 | 2 | 2019-03-06 16:15:30 | 1 | Metro |
| 7464 | 7730 | 2 | 2019-03-06 16:15:50 | 1 | Metro |
| 7465 | 7759 | 2 | 2019-03-07 09:14:22 | 1 | Metro |
| 7466 | 7757 | 2 | 2019-03-07 09:14:38 | 1 | Metro |
| 7467 | 7761 | 2 | 2019-03-07 09:14:46 | 1 | Metro |
| 7468 | 7758 | 2 | 2019-03-07 09:15:00 | 1 | Metro |
| 7469 | 7760 | 2 | 2019-03-07 09:15:06 | 1 | Metro |
| 7470 | 7774 | 2 | 2019-03-07 10:42:54 | 1 | Private Vehicle |
| 7471 | 7731 | 5 | 2019-03-08 09:08:00 | 1 | Walk |
| 7472 | 7732 | 5 | 2019-03-08 09:08:01 | 1 | Walk |
| 7473 | 7735 | 5 | 2019-03-08 09:08:02 | 1 | Walk |
| 7474 | 7734 | 5 | 2019-03-08 09:08:06 | 1 | Walk |
| 7475 | 7733 | 5 | 2019-03-08 09:08:27 | 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;