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,601–4,625 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 4601 | 4106 | 1 | 2017-10-26 12:26:57 | 1 | Bus |
| 4602 | 4107 | 1 | 2017-10-26 12:27:00 | 1 | Bus |
| 4603 | 4109 | 1 | 2017-10-26 12:27:28 | 1 | Bus |
| 4604 | 4117 | 1 | 2017-10-26 12:27:37 | 1 | Bus |
| 4605 | 4120 | 1 | 2017-10-26 12:27:40 | 1 | Bus |
| 4606 | 4112 | 1 | 2017-10-26 12:27:42 | 1 | Bus |
| 4607 | 4121 | 1 | 2017-10-26 12:27:44 | 1 | Bus |
| 4608 | 4110 | 1 | 2017-10-26 12:27:52 | 1 | Bus |
| 4609 | 4118 | 1 | 2017-10-26 12:27:52 | 1 | Bus |
| 4610 | 4116 | 1 | 2017-10-26 12:28:20 | 1 | Bus |
| 4611 | 4113 | 1 | 2017-10-26 12:28:22 | 1 | Bus |
| 4612 | 4123 | 1 | 2017-10-26 12:28:22 | 1 | Bus |
| 4613 | 4115 | 1 | 2017-10-26 12:28:37 | 1 | Bus |
| 4614 | 4132 | 1 | 2017-10-26 12:28:58 | 1 | Bus |
| 4615 | 4119 | 1 | 2017-10-26 12:29:04 | 1 | Bus |
| 4616 | 4128 | 1 | 2017-10-26 12:29:16 | 1 | Bus |
| 4617 | 4125 | 1 | 2017-10-26 12:29:32 | 1 | Bus |
| 4618 | 4135 | 1 | 2017-10-26 12:29:33 | 1 | Bus |
| 4619 | 4137 | 1 | 2017-10-26 12:29:47 | 1 | Bus |
| 4620 | 4122 | 1 | 2017-10-26 12:30:22 | 1 | Bus |
| 4621 | 4130 | 1 | 2017-10-26 12:30:32 | 1 | Bus |
| 4622 | 4133 | 1 | 2017-10-26 12:30:32 | 1 | Bus |
| 4623 | 4138 | 1 | 2017-10-26 12:30:46 | 1 | Bus |
| 4624 | 4127 | 1 | 2017-10-26 12:30:50 | 1 | Bus |
| 4625 | 4129 | 1 | 2017-10-26 12:31:18 | 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;