Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 9,001–9,025 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 9001 | 9182 | 1 | 2019-10-26 11:32:35 | 1 | Metro |
| 9002 | 9183 | 1 | 2019-10-26 11:32:44 | 1 | Metro |
| 9003 | 9237 | 1 | 2019-10-26 14:56:15 | 1 | Train |
| 9004 | 9238 | 1 | 2019-10-26 14:56:24 | 1 | Train |
| 9005 | 9236 | 1 | 2019-10-26 14:56:28 | 1 | Train |
| 9006 | 9309 | 2 | 2019-10-27 15:04:36 | 1 | Metro |
| 9007 | 9310 | 2 | 2019-10-27 15:04:50 | 1 | Metro |
| 9008 | 9173 | 4 | 2019-10-28 11:30:28 | 1 | Walk |
| 9009 | 9322 | 2 | 2019-10-28 11:39:06 | 1 | Private Vehicle |
| 9010 | 9173 | 1 | 2019-10-28 13:30:45 | 0 | NULL |
| 9011 | 9319 | 4 | 2019-10-28 13:44:29 | 1 | Walk |
| 9012 | 9318 | 4 | 2019-10-28 13:44:47 | 1 | Walk |
| 9013 | 9325 | 1 | 2019-10-28 14:16:00 | 1 | Train |
| 9014 | 9121 | 4 | 2019-10-28 14:26:47 | 1 | Walk |
| 9015 | 9322 | 2 | 2019-10-28 14:29:38 | 0 | NULL |
| 9016 | 9321 | 1 | 2019-10-29 09:50:05 | 1 | Metro |
| 9017 | 9320 | 1 | 2019-10-29 09:50:43 | 1 | Metro |
| 9018 | 9312 | 1 | 2019-10-29 10:28:58 | 1 | Walk |
| 9019 | 9311 | 1 | 2019-10-29 10:29:45 | 1 | Walk |
| 9020 | 9329 | 5 | 2019-10-29 11:33:42 | 1 | Walk |
| 9021 | 9330 | 5 | 2019-10-29 11:33:50 | 1 | Walk |
| 9022 | 9327 | 4 | 2019-10-29 11:43:47 | 1 | Walk |
| 9023 | 9326 | 4 | 2019-10-29 11:44:23 | 1 | Walk |
| 9024 | 9314 | 2 | 2019-10-29 13:11:35 | 1 | Bus |
| 9025 | 9317 | 2 | 2019-10-29 13:11:40 | 1 | Bus |
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;