Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 326–350 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 326 | 535 | 1 | 2015-05-16 09:40:19 | 1 | Other |
| 327 | 537 | 1 | 2015-05-16 15:15:12 | 1 | Metro |
| 328 | 521 | 1 | 2015-05-17 11:29:46 | 1 | Taxi |
| 329 | 520 | 1 | 2015-05-17 11:29:50 | 1 | Taxi |
| 330 | 519 | 1 | 2015-05-17 11:29:52 | 1 | Taxi |
| 331 | 522 | 1 | 2015-05-17 11:30:23 | 1 | Taxi |
| 332 | 539 | 3 | 2015-05-17 14:04:42 | 1 | Taxi |
| 333 | 538 | 3 | 2015-05-17 14:05:03 | 1 | Taxi |
| 334 | 541 | 5 | 2015-05-18 10:26:50 | 1 | Metro |
| 335 | 542 | 5 | 2015-05-18 10:27:33 | 1 | Metro |
| 336 | 543 | 4 | 2015-05-18 11:00:12 | 1 | Walk |
| 337 | 544 | 4 | 2015-05-18 11:00:33 | 1 | Walk |
| 338 | 545 | 3 | 2015-05-18 14:05:18 | 1 | Walk |
| 339 | 506 | 2 | 2015-05-18 14:19:25 | 1 | Bus |
| 340 | 300 | 1 | 2015-05-18 14:46:57 | 1 | Walk |
| 341 | 301 | 1 | 2015-05-18 14:47:25 | 1 | Walk |
| 342 | 548 | 1 | 2015-05-20 15:25:27 | 1 | Other |
| 343 | 549 | 1 | 2015-05-20 15:25:39 | 1 | Other |
| 344 | 550 | 2 | 2015-05-20 15:42:23 | 1 | Train |
| 345 | 523 | 4 | 2015-05-21 11:25:18 | 1 | Metro |
| 346 | 546 | 4 | 2015-05-21 11:31:18 | 1 | Walk |
| 347 | 547 | 4 | 2015-05-21 11:31:46 | 1 | Walk |
| 348 | 601 | 1 | 2015-05-21 14:03:17 | 1 | Metro |
| 349 | 602 | 1 | 2015-05-22 10:04:13 | 1 | Train |
| 350 | 320 | 5 | 2015-05-22 10:37:35 | 1 | Taxi |
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;