Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 126–150 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 126 | 274 | 1 | 2015-04-11 16:15:23 | 1 | Bus |
| 127 | 273 | 1 | 2015-04-11 16:15:41 | 1 | Bus |
| 128 | 240 | 2 | 2015-04-12 14:21:44 | 1 | Metro |
| 129 | 275 | 1 | 2015-04-12 15:59:24 | 1 | Walk |
| 130 | 276 | 1 | 2015-04-12 15:59:26 | 1 | Walk |
| 131 | 277 | 1 | 2015-04-12 15:59:32 | 1 | Walk |
| 132 | 278 | 4 | 2015-04-13 09:33:03 | 1 | Metro |
| 133 | 255 | 1 | 2015-04-13 10:21:18 | 1 | Train |
| 134 | 280 | 4 | 2015-04-13 10:59:49 | 1 | Taxi |
| 135 | 279 | 4 | 2015-04-13 11:00:13 | 1 | Taxi |
| 136 | 214 | 1 | 2015-04-14 10:20:56 | 1 | Other |
| 137 | 215 | 1 | 2015-04-14 10:21:12 | 1 | Other |
| 138 | 282 | 1 | 2015-04-14 11:27:51 | 1 | Metro |
| 139 | 266 | 1 | 2015-04-15 12:49:19 | 1 | Walk |
| 140 | 283 | 1 | 2015-04-15 13:47:12 | 1 | Taxi |
| 141 | 202 | 2 | 2015-04-16 11:07:46 | 1 | Metro |
| 142 | 284 | 4 | 2015-04-17 12:24:24 | 1 | Metro |
| 143 | 253 | 2 | 2015-04-17 17:00:12 | 1 | Private Vehicle |
| 144 | 252 | 2 | 2015-04-17 17:00:38 | 1 | Private Vehicle |
| 145 | 290 | 4 | 2015-04-18 10:52:56 | 1 | Walk |
| 146 | 289 | 4 | 2015-04-18 10:53:11 | 1 | Walk |
| 147 | 293 | 3 | 2015-04-18 11:46:19 | 1 | Taxi |
| 148 | 292 | 3 | 2015-04-18 11:46:49 | 1 | Taxi |
| 149 | 285 | 2 | 2015-04-19 11:03:52 | 1 | Walk |
| 150 | 286 | 2 | 2015-04-19 11:03:57 | 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;