Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 4,501–4,525 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 4501 | 4655 | 5 | 2017-10-01 10:30:25 | 1 | Metro |
| 4502 | 4658 | 2 | 2017-10-01 15:00:09 | 1 | Metro |
| 4503 | 4659 | 2 | 2017-10-01 15:00:30 | 1 | Metro |
| 4504 | 4742 | 1 | 2017-10-02 09:26:40 | 1 | Taxi |
| 4505 | 4744 | 4 | 2017-10-02 10:38:11 | 1 | Taxi |
| 4506 | 4743 | 4 | 2017-10-02 10:38:12 | 1 | Taxi |
| 4507 | 4682 | 1 | 2017-10-05 16:00:05 | 1 | Walk |
| 4508 | 4681 | 1 | 2017-10-05 16:00:12 | 1 | Walk |
| 4509 | 4680 | 1 | 2017-10-05 16:00:29 | 1 | Walk |
| 4510 | 4752 | 5 | 2017-10-07 10:52:34 | 1 | Walk |
| 4511 | 4757 | 1 | 2017-10-09 16:43:21 | 1 | Walk |
| 4512 | 4763 | 4 | 2017-10-10 09:12:13 | 1 | Metro |
| 4513 | 4762 | 4 | 2017-10-10 09:12:31 | 1 | Metro |
| 4514 | 4594 | 1 | 2017-10-10 09:31:21 | 1 | Bus |
| 4515 | 4595 | 1 | 2017-10-10 09:31:26 | 1 | Bus |
| 4516 | 4598 | 1 | 2017-10-10 09:31:37 | 1 | Bus |
| 4517 | 4596 | 1 | 2017-10-10 09:31:45 | 1 | Bus |
| 4518 | 4597 | 1 | 2017-10-10 09:32:00 | 1 | Bus |
| 4519 | 4602 | 1 | 2017-10-10 09:32:09 | 1 | Bus |
| 4520 | 4599 | 1 | 2017-10-10 09:32:11 | 1 | Bus |
| 4521 | 4600 | 1 | 2017-10-10 09:32:15 | 1 | Bus |
| 4522 | 4604 | 1 | 2017-10-10 09:32:21 | 1 | Bus |
| 4523 | 4603 | 1 | 2017-10-10 09:32:24 | 1 | Bus |
| 4524 | 4611 | 1 | 2017-10-10 09:32:29 | 1 | Bus |
| 4525 | 4601 | 1 | 2017-10-10 09:32:31 | 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;