Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 401–425 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 401 | 149 | 4 | 2015-05-28 10:04:53 | 1 | Bus |
| 402 | 150 | 4 | 2015-05-28 10:05:04 | 1 | Bus |
| 403 | 147 | 4 | 2015-05-28 10:05:23 | 1 | Bus |
| 404 | 146 | 4 | 2015-05-28 10:06:00 | 1 | Bus |
| 405 | 155 | 4 | 2015-05-28 10:07:13 | 1 | Bus |
| 406 | 151 | 4 | 2015-05-28 10:07:15 | 1 | Bus |
| 407 | 502 | 4 | 2015-05-28 10:31:04 | 1 | Walk |
| 408 | 503 | 4 | 2015-05-28 10:31:14 | 1 | Walk |
| 409 | 610 | 1 | 2015-05-28 10:33:13 | 1 | Metro |
| 410 | 615 | 3 | 2015-05-29 09:50:54 | 1 | Walk |
| 411 | 617 | 5 | 2015-05-29 10:52:55 | 1 | Metro |
| 412 | 619 | 5 | 2015-05-29 10:53:05 | 1 | Metro |
| 413 | 618 | 5 | 2015-05-29 10:53:13 | 1 | Metro |
| 414 | 616 | 5 | 2015-05-29 10:53:33 | 1 | Metro |
| 415 | 432 | 4 | 2015-05-30 10:00:06 | 1 | Metro |
| 416 | 433 | 4 | 2015-05-30 10:00:11 | 1 | Metro |
| 417 | 434 | 4 | 2015-05-30 10:00:11 | 1 | Metro |
| 418 | 600 | 4 | 2015-05-31 15:56:52 | 1 | Walk |
| 419 | 599 | 4 | 2015-05-31 15:56:57 | 1 | Walk |
| 420 | 540 | 1 | 2015-05-31 16:49:56 | 1 | Other |
| 421 | 622 | 1 | 2015-06-01 13:18:06 | 1 | Walk |
| 422 | 623 | 1 | 2015-06-01 13:18:26 | 1 | Walk |
| 423 | 630 | 1 | 2015-06-03 11:23:34 | 1 | Metro |
| 424 | 631 | 1 | 2015-06-03 11:24:06 | 1 | Metro |
| 425 | 633 | 4 | 2015-06-06 10:21:23 | 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;