Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 3,401–3,425 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 3401 | 3259 | 4 | 2017-03-15 11:21:38 | 1 | Walk |
| 3402 | 3258 | 4 | 2017-03-15 11:21:50 | 1 | Walk |
| 3403 | 3261 | 4 | 2017-03-15 11:22:02 | 1 | Walk |
| 3404 | 3265 | 4 | 2017-03-15 11:22:02 | 1 | Walk |
| 3405 | 3268 | 4 | 2017-03-15 11:22:20 | 1 | Walk |
| 3406 | 3272 | 4 | 2017-03-15 11:22:25 | 1 | Walk |
| 3407 | 3260 | 4 | 2017-03-15 11:22:28 | 1 | Walk |
| 3408 | 3284 | 4 | 2017-03-15 11:22:54 | 1 | Walk |
| 3409 | 3274 | 4 | 2017-03-15 11:22:56 | 1 | Walk |
| 3410 | 3269 | 4 | 2017-03-15 11:22:58 | 1 | Walk |
| 3411 | 3270 | 4 | 2017-03-15 11:23:06 | 1 | Walk |
| 3412 | 3276 | 4 | 2017-03-15 11:23:08 | 1 | Walk |
| 3413 | 3263 | 4 | 2017-03-15 11:23:10 | 1 | Walk |
| 3414 | 3264 | 4 | 2017-03-15 11:23:13 | 1 | Walk |
| 3415 | 3266 | 4 | 2017-03-15 11:23:13 | 1 | Walk |
| 3416 | 3279 | 4 | 2017-03-15 11:23:26 | 1 | Walk |
| 3417 | 3295 | 4 | 2017-03-15 11:23:38 | 1 | Walk |
| 3418 | 3285 | 4 | 2017-03-15 11:24:02 | 1 | Walk |
| 3419 | 3281 | 4 | 2017-03-15 11:24:06 | 1 | Walk |
| 3420 | 3273 | 4 | 2017-03-15 11:24:10 | 1 | Walk |
| 3421 | 3267 | 4 | 2017-03-15 11:24:20 | 1 | Walk |
| 3422 | 3296 | 4 | 2017-03-15 11:24:25 | 1 | Walk |
| 3423 | 3282 | 4 | 2017-03-15 11:24:42 | 1 | Walk |
| 3424 | 3280 | 4 | 2017-03-15 11:24:53 | 1 | Walk |
| 3425 | 3271 | 4 | 2017-03-15 11:25:02 | 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;