Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 101–125 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 101 | 249 | 1 | 2015-04-05 11:15:38 | 1 | Metro |
| 102 | 250 | 1 | 2015-04-05 11:16:01 | 1 | Metro |
| 103 | 247 | 1 | 2015-04-05 11:16:04 | 1 | Metro |
| 104 | 251 | 1 | 2015-04-05 11:16:07 | 1 | Metro |
| 105 | 248 | 1 | 2015-04-05 11:16:16 | 1 | Metro |
| 106 | 254 | 3 | 2015-04-05 12:46:12 | 1 | Metro |
| 107 | 256 | 3 | 2015-04-06 11:00:20 | 1 | Metro |
| 108 | 257 | 3 | 2015-04-06 11:00:33 | 1 | Metro |
| 109 | 258 | 1 | 2015-04-06 11:21:58 | 1 | Walk |
| 110 | 259 | 1 | 2015-04-06 11:21:58 | 1 | Walk |
| 111 | 257 | 3 | 2015-04-06 13:06:59 | 0 | NULL |
| 112 | 256 | 3 | 2015-04-06 14:55:42 | 0 | NULL |
| 113 | 216 | 3 | 2015-04-07 10:45:07 | 1 | Metro |
| 114 | 106 | 5 | 2015-04-08 14:09:29 | 1 | Bus |
| 115 | 265 | 3 | 2015-04-09 10:28:01 | 1 | Taxi |
| 116 | 262 | 3 | 2015-04-09 10:28:21 | 1 | Taxi |
| 117 | 263 | 3 | 2015-04-09 10:28:22 | 1 | Taxi |
| 118 | 264 | 3 | 2015-04-09 10:28:33 | 1 | Taxi |
| 119 | 267 | 1 | 2015-04-10 09:53:37 | 1 | Metro |
| 120 | 268 | 2 | 2015-04-10 10:28:34 | 1 | Private Vehicle |
| 121 | 269 | 2 | 2015-04-10 10:28:48 | 1 | Private Vehicle |
| 122 | 270 | 1 | 2015-04-10 14:01:28 | 1 | Walk |
| 123 | 233 | 1 | 2015-04-11 09:54:37 | 1 | Train |
| 124 | 272 | 1 | 2015-04-11 16:14:54 | 1 | Bus |
| 125 | 271 | 1 | 2015-04-11 16:15:07 | 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;