Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 5,351–5,375 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 5351 | 5559 | 2 | 2018-04-13 10:20:10 | 1 | Metro |
| 5352 | 5558 | 2 | 2018-04-13 10:20:27 | 1 | Metro |
| 5353 | 5560 | 2 | 2018-04-13 10:20:36 | 1 | Metro |
| 5354 | 5549 | 2 | 2018-04-13 16:44:20 | 1 | Private Vehicle |
| 5355 | 5551 | 2 | 2018-04-13 16:44:23 | 1 | Private Vehicle |
| 5356 | 5550 | 2 | 2018-04-13 16:44:34 | 1 | Private Vehicle |
| 5357 | 5567 | 5 | 2018-04-14 10:48:05 | 1 | Walk |
| 5358 | 5565 | 5 | 2018-04-14 10:48:15 | 1 | Walk |
| 5359 | 5566 | 5 | 2018-04-14 10:48:25 | 1 | Walk |
| 5360 | 5564 | 5 | 2018-04-14 10:48:26 | 1 | Walk |
| 5361 | 5568 | 5 | 2018-04-14 10:48:32 | 1 | Walk |
| 5362 | 5544 | 1 | 2018-04-15 11:58:47 | 1 | Metro |
| 5363 | 5572 | 4 | 2018-04-15 14:36:44 | 1 | Walk |
| 5364 | 5523 | 5 | 2018-04-15 15:44:12 | 1 | Walk |
| 5365 | 5501 | 1 | 2018-04-16 09:27:43 | 1 | Walk |
| 5366 | 5522 | 3 | 2018-04-16 14:37:35 | 1 | Bus |
| 5367 | 5371 | 2 | 2018-04-16 16:21:11 | 1 | Walk |
| 5368 | 5372 | 2 | 2018-04-16 16:21:56 | 1 | Walk |
| 5369 | 5557 | 2 | 2018-04-17 12:57:35 | 1 | Other |
| 5370 | 5563 | 2 | 2018-04-18 09:32:01 | 1 | Metro |
| 5371 | 5562 | 2 | 2018-04-18 09:32:19 | 1 | Metro |
| 5372 | 5583 | 2 | 2018-04-18 11:52:36 | 1 | Taxi |
| 5373 | 5293 | 4 | 2018-04-18 14:25:01 | 1 | Walk |
| 5374 | 5292 | 4 | 2018-04-18 14:25:10 | 1 | Walk |
| 5375 | 5532 | 1 | 2018-04-18 14:51:22 | 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;