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,226–9,250 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 9226 | 9455 | 2 | 2019-11-23 11:06:10 | 1 | Walk |
| 9227 | 9464 | 2 | 2019-11-23 12:14:56 | 1 | Metro |
| 9228 | 9463 | 2 | 2019-11-23 12:15:03 | 1 | Metro |
| 9229 | 9434 | 2 | 2019-11-23 15:21:33 | 1 | Metro |
| 9230 | 9423 | 2 | 2019-11-24 10:32:14 | 1 | Metro |
| 9231 | 9436 | 2 | 2019-11-25 10:01:52 | 1 | Metro |
| 9232 | 9435 | 2 | 2019-11-25 10:02:01 | 1 | Metro |
| 9233 | 9451 | 1 | 2019-11-26 10:35:56 | 1 | Metro |
| 9234 | 9450 | 1 | 2019-11-26 10:36:12 | 1 | Metro |
| 9235 | 9453 | 1 | 2019-11-26 10:36:14 | 1 | Metro |
| 9236 | 9452 | 1 | 2019-11-26 10:36:25 | 1 | Metro |
| 9237 | 9449 | 1 | 2019-11-26 10:36:28 | 1 | Metro |
| 9238 | 9481 | 1 | 2019-11-28 09:16:37 | 1 | Walk |
| 9239 | 9482 | 1 | 2019-11-28 09:16:37 | 1 | Walk |
| 9240 | 9480 | 1 | 2019-11-28 09:16:42 | 1 | Walk |
| 9241 | 9483 | 1 | 2019-11-28 09:17:04 | 1 | Walk |
| 9242 | 9375 | 1 | 2019-11-28 09:32:58 | 1 | Metro |
| 9243 | 9376 | 1 | 2019-11-28 09:33:10 | 1 | Metro |
| 9244 | 9381 | 4 | 2019-11-28 09:38:41 | 1 | Walk |
| 9245 | 9429 | 2 | 2019-11-28 13:11:23 | 1 | Walk |
| 9246 | 9428 | 2 | 2019-11-28 13:11:35 | 1 | Walk |
| 9247 | 9473 | 2 | 2019-11-28 15:35:47 | 1 | Train |
| 9248 | 9471 | 2 | 2019-11-28 15:35:52 | 1 | Train |
| 9249 | 9470 | 2 | 2019-11-28 15:36:01 | 1 | Train |
| 9250 | 9472 | 2 | 2019-11-28 15:36:15 | 1 | Train |
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;