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,176–7,200 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 7176 | 7264 | 1 | 2019-01-05 16:28:07 | 1 | Walk |
| 7177 | 7372 | 2 | 2019-01-06 10:11:07 | 1 | Bus |
| 7178 | 7371 | 2 | 2019-01-06 10:11:15 | 1 | Bus |
| 7179 | 7377 | 1 | 2019-01-06 12:44:43 | 1 | Metro |
| 7180 | 7378 | 4 | 2019-01-06 14:07:18 | 1 | Walk |
| 7181 | 7374 | 1 | 2019-01-08 15:21:39 | 1 | Metro |
| 7182 | 7376 | 1 | 2019-01-08 15:21:41 | 1 | Metro |
| 7183 | 7375 | 1 | 2019-01-08 15:21:50 | 1 | Metro |
| 7184 | 7373 | 1 | 2019-01-08 15:22:23 | 1 | Metro |
| 7185 | 7381 | 2 | 2019-01-09 10:07:26 | 1 | Walk |
| 7186 | 7380 | 2 | 2019-01-09 10:07:41 | 1 | Walk |
| 7187 | 7353 | 2 | 2019-01-09 12:56:50 | 1 | Metro |
| 7188 | 7355 | 2 | 2019-01-09 12:56:56 | 1 | Metro |
| 7189 | 7354 | 2 | 2019-01-09 12:57:11 | 1 | Metro |
| 7190 | 7352 | 2 | 2019-01-09 12:57:22 | 1 | Metro |
| 7191 | 7379 | 1 | 2019-01-10 11:01:00 | 1 | Walk |
| 7192 | 7382 | 4 | 2019-01-12 10:02:26 | 1 | Private Vehicle |
| 7193 | 7385 | 3 | 2019-01-12 10:32:05 | 1 | Other |
| 7194 | 7386 | 4 | 2019-01-12 10:54:37 | 1 | Metro |
| 7195 | 7387 | 4 | 2019-01-12 10:54:48 | 1 | Metro |
| 7196 | 7254 | 1 | 2019-01-12 10:59:18 | 1 | Bus |
| 7197 | 7255 | 1 | 2019-01-12 10:59:48 | 1 | Bus |
| 7198 | 7445 | 3 | 2019-01-14 13:46:13 | 1 | Walk |
| 7199 | 7444 | 3 | 2019-01-14 13:46:27 | 1 | Walk |
| 7200 | 7383 | 3 | 2019-01-17 11:52:07 | 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;