Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 7,351–7,375 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 7351 | 7435 | 1 | 2019-02-19 09:45:09 | 1 | Bus |
| 7352 | 7443 | 1 | 2019-02-19 09:47:01 | 1 | Bus |
| 7353 | 7465 | 2 | 2019-02-19 10:12:28 | 1 | Walk |
| 7354 | 7464 | 2 | 2019-02-19 10:12:31 | 1 | Walk |
| 7355 | 7656 | 3 | 2019-02-19 10:30:22 | 1 | Metro |
| 7356 | 7601 | 1 | 2019-02-19 13:02:57 | 1 | Metro |
| 7357 | 7645 | 1 | 2019-02-20 09:05:41 | 1 | Metro |
| 7358 | 7474 | 3 | 2019-02-21 11:41:24 | 1 | Walk |
| 7359 | 7712 | 4 | 2019-02-22 11:19:46 | 1 | Walk |
| 7360 | 7718 | 1 | 2019-02-22 13:47:54 | 1 | Walk |
| 7361 | 7720 | 2 | 2019-02-23 09:47:00 | 1 | Bus |
| 7362 | 7721 | 2 | 2019-02-23 09:47:24 | 1 | Bus |
| 7363 | 7725 | 2 | 2019-02-24 11:32:46 | 1 | Taxi |
| 7364 | 7724 | 2 | 2019-02-24 11:32:55 | 1 | Taxi |
| 7365 | 7724 | 1 | 2019-02-24 14:22:26 | 0 | NULL |
| 7366 | 7725 | 1 | 2019-02-24 15:30:32 | 0 | NULL |
| 7367 | 7719 | 5 | 2019-02-25 15:22:36 | 1 | Walk |
| 7368 | 7085 | 4 | 2019-02-27 12:47:05 | 1 | Metro |
| 7369 | 7088 | 4 | 2019-02-27 12:47:17 | 1 | Metro |
| 7370 | 7086 | 4 | 2019-02-27 12:47:19 | 1 | Metro |
| 7371 | 7087 | 4 | 2019-02-27 12:47:23 | 1 | Metro |
| 7372 | 7090 | 4 | 2019-02-27 12:47:35 | 1 | Metro |
| 7373 | 7091 | 4 | 2019-02-27 12:47:35 | 1 | Metro |
| 7374 | 7094 | 4 | 2019-02-27 12:47:41 | 1 | Metro |
| 7375 | 7089 | 4 | 2019-02-27 12:47:53 | 1 | Metro |
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;