Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 6,101–6,125 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 6101 | 6428 | 2 | 2018-08-09 11:31:48 | 1 | Walk |
| 6102 | 6429 | 2 | 2018-08-09 11:31:48 | 1 | Walk |
| 6103 | 6427 | 2 | 2018-08-09 11:32:19 | 1 | Walk |
| 6104 | 6426 | 2 | 2018-08-09 11:32:21 | 1 | Walk |
| 6105 | 6345 | 1 | 2018-08-09 11:38:14 | 1 | Other |
| 6106 | 6432 | 1 | 2018-08-09 13:42:04 | 1 | Metro |
| 6107 | 6430 | 1 | 2018-08-09 13:42:20 | 1 | Metro |
| 6108 | 6431 | 1 | 2018-08-09 13:42:22 | 1 | Metro |
| 6109 | 6433 | 1 | 2018-08-09 13:42:37 | 1 | Metro |
| 6110 | 5590 | 1 | 2018-08-10 11:01:11 | 1 | Walk |
| 6111 | 5592 | 1 | 2018-08-10 11:01:19 | 1 | Walk |
| 6112 | 5591 | 1 | 2018-08-10 11:01:20 | 1 | Walk |
| 6113 | 5593 | 1 | 2018-08-10 11:01:29 | 1 | Walk |
| 6114 | 5604 | 1 | 2018-08-10 11:01:51 | 1 | Walk |
| 6115 | 5596 | 1 | 2018-08-10 11:01:56 | 1 | Walk |
| 6116 | 5595 | 1 | 2018-08-10 11:02:07 | 1 | Walk |
| 6117 | 5608 | 1 | 2018-08-10 11:02:07 | 1 | Walk |
| 6118 | 5603 | 1 | 2018-08-10 11:02:23 | 1 | Walk |
| 6119 | 5598 | 1 | 2018-08-10 11:02:35 | 1 | Walk |
| 6120 | 5602 | 1 | 2018-08-10 11:02:47 | 1 | Walk |
| 6121 | 5600 | 1 | 2018-08-10 11:02:56 | 1 | Walk |
| 6122 | 5613 | 1 | 2018-08-10 11:02:59 | 1 | Walk |
| 6123 | 5606 | 1 | 2018-08-10 11:03:11 | 1 | Walk |
| 6124 | 5605 | 1 | 2018-08-10 11:03:23 | 1 | Walk |
| 6125 | 5609 | 1 | 2018-08-10 11:03:26 | 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;