Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 6,401–6,425 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 6401 | 6594 | 1 | 2018-08-31 13:04:11 | 0 | NULL |
| 6402 | 6597 | 3 | 2018-08-31 13:19:01 | 0 | NULL |
| 6403 | 6564 | 1 | 2018-08-31 14:12:43 | 1 | Walk |
| 6404 | 6565 | 1 | 2018-08-31 14:12:54 | 1 | Walk |
| 6405 | 6600 | 1 | 2018-08-31 15:00:57 | 1 | Walk |
| 6406 | 6601 | 1 | 2018-08-31 15:01:11 | 1 | Walk |
| 6407 | 6598 | 1 | 2018-08-31 15:01:28 | 1 | Walk |
| 6408 | 6599 | 1 | 2018-08-31 15:01:31 | 1 | Walk |
| 6409 | 6442 | 1 | 2018-09-01 16:21:37 | 1 | Train |
| 6410 | 6603 | 5 | 2018-09-02 09:58:02 | 1 | Walk |
| 6411 | 6602 | 5 | 2018-09-02 09:58:22 | 1 | Walk |
| 6412 | 6604 | 1 | 2018-09-02 10:26:04 | 1 | Walk |
| 6413 | 6606 | 1 | 2018-09-02 10:26:06 | 1 | Walk |
| 6414 | 6605 | 1 | 2018-09-02 10:26:12 | 1 | Walk |
| 6415 | 6607 | 1 | 2018-09-02 10:26:43 | 1 | Walk |
| 6416 | 6608 | 1 | 2018-09-02 10:26:44 | 1 | Walk |
| 6417 | 6590 | 2 | 2018-09-02 11:21:23 | 1 | Metro |
| 6418 | 6591 | 2 | 2018-09-02 11:21:23 | 1 | Metro |
| 6419 | 6588 | 2 | 2018-09-02 11:21:32 | 1 | Metro |
| 6420 | 6589 | 2 | 2018-09-02 11:21:32 | 1 | Metro |
| 6421 | 6592 | 2 | 2018-09-02 11:21:50 | 1 | Metro |
| 6422 | 6583 | 3 | 2018-09-03 12:15:45 | 1 | Metro |
| 6423 | 6584 | 3 | 2018-09-03 12:16:30 | 1 | Metro |
| 6424 | 6557 | 1 | 2018-09-03 13:59:07 | 1 | Walk |
| 6425 | 6558 | 1 | 2018-09-03 13:59:10 | 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;