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,476–9,500 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 9476 | 9564 | 1 | 2019-12-28 11:10:10 | 1 | Bus |
| 9477 | 9558 | 1 | 2019-12-28 11:48:54 | 1 | Bus |
| 9478 | 9617 | 1 | 2019-12-28 12:07:16 | 1 | Metro |
| 9479 | 9572 | 1 | 2019-12-28 12:32:39 | 1 | Metro |
| 9480 | 9573 | 1 | 2019-12-28 12:33:10 | 1 | Metro |
| 9481 | 9573 | 1 | 2019-12-28 14:13:45 | 0 | NULL |
| 9482 | 9572 | 1 | 2019-12-28 14:54:47 | 0 | NULL |
| 9483 | 9571 | 1 | 2019-12-28 16:26:31 | 1 | Metro |
| 9484 | 9567 | 2 | 2019-12-28 16:30:05 | 1 | Walk |
| 9485 | 9620 | 2 | 2019-12-29 09:42:33 | 1 | Metro |
| 9486 | 9621 | 1 | 2019-12-29 11:06:38 | 1 | Metro |
| 9487 | 9622 | 1 | 2019-12-29 11:07:17 | 1 | Metro |
| 9488 | 9590 | 1 | 2019-12-29 13:20:48 | 1 | Walk |
| 9489 | 9624 | 1 | 2019-12-30 09:04:34 | 1 | Metro |
| 9490 | 9623 | 1 | 2019-12-30 09:05:19 | 1 | Metro |
| 9491 | 9524 | 1 | 2019-12-30 09:43:53 | 1 | Walk |
| 9492 | 9525 | 1 | 2019-12-30 09:44:09 | 1 | Walk |
| 9493 | 9625 | 2 | 2019-12-30 11:01:59 | 1 | Walk |
| 9494 | 9581 | 2 | 2019-12-30 11:46:45 | 1 | Metro |
| 9495 | 9627 | 1 | 2019-12-30 11:47:26 | 1 | Metro |
| 9496 | 9626 | 1 | 2019-12-30 11:47:27 | 1 | Metro |
| 9497 | 9479 | 1 | 2019-12-31 11:24:12 | 1 | Metro |
| 9498 | 9611 | 4 | 2020-01-01 10:00:03 | 1 | Taxi |
| 9499 | 9609 | 4 | 2020-01-01 10:00:18 | 1 | Taxi |
| 9500 | 9612 | 4 | 2020-01-01 10:00:18 | 1 | Taxi |
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;