Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 76–100 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 76 | 108 | 1 | 2015-03-31 09:23:20 | 1 | Train |
| 77 | 171 | 4 | 2015-03-31 14:11:44 | 1 | Taxi |
| 78 | 170 | 4 | 2015-03-31 14:11:46 | 1 | Taxi |
| 79 | 221 | 5 | 2015-04-01 09:51:26 | 1 | Walk |
| 80 | 223 | 4 | 2015-04-01 14:18:25 | 1 | Metro |
| 81 | 226 | 4 | 2015-04-01 14:18:33 | 1 | Metro |
| 82 | 225 | 4 | 2015-04-01 14:18:55 | 1 | Metro |
| 83 | 224 | 4 | 2015-04-01 14:18:57 | 1 | Metro |
| 84 | 230 | 1 | 2015-04-02 15:27:09 | 1 | Walk |
| 85 | 236 | 1 | 2015-04-04 09:41:14 | 1 | Walk |
| 86 | 235 | 1 | 2015-04-04 09:41:44 | 1 | Walk |
| 87 | 232 | 3 | 2015-04-04 09:52:47 | 1 | Walk |
| 88 | 231 | 3 | 2015-04-04 09:52:53 | 1 | Walk |
| 89 | 222 | 5 | 2015-04-04 10:10:13 | 1 | Walk |
| 90 | 232 | 3 | 2015-04-04 11:24:03 | 0 | NULL |
| 91 | 231 | 3 | 2015-04-04 13:51:50 | 0 | NULL |
| 92 | 239 | 3 | 2015-04-04 14:28:02 | 1 | Walk |
| 93 | 238 | 3 | 2015-04-04 14:28:23 | 1 | Walk |
| 94 | 237 | 3 | 2015-04-04 14:28:32 | 1 | Walk |
| 95 | 241 | 3 | 2015-04-05 09:32:23 | 1 | Metro |
| 96 | 242 | 3 | 2015-04-05 09:32:44 | 1 | Metro |
| 97 | 243 | 2 | 2015-04-05 09:51:42 | 1 | Taxi |
| 98 | 245 | 2 | 2015-04-05 09:51:52 | 1 | Taxi |
| 99 | 244 | 2 | 2015-04-05 09:51:57 | 1 | Taxi |
| 100 | 246 | 2 | 2015-04-05 09:52:14 | 1 | Taxi |
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;