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,526–7,550 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 7526 | 7500 | 1 | 2019-03-15 13:02:59 | 1 | Metro |
| 7527 | 7513 | 1 | 2019-03-15 13:03:05 | 1 | Metro |
| 7528 | 7507 | 1 | 2019-03-15 13:03:11 | 1 | Metro |
| 7529 | 7493 | 1 | 2019-03-15 13:03:21 | 1 | Metro |
| 7530 | 7501 | 1 | 2019-03-15 13:03:29 | 1 | Metro |
| 7531 | 7494 | 1 | 2019-03-15 13:03:31 | 1 | Metro |
| 7532 | 7489 | 1 | 2019-03-15 13:03:41 | 1 | Metro |
| 7533 | 7497 | 1 | 2019-03-15 13:04:01 | 1 | Metro |
| 7534 | 7492 | 1 | 2019-03-15 13:04:11 | 1 | Metro |
| 7535 | 7514 | 1 | 2019-03-15 13:04:23 | 1 | Metro |
| 7536 | 7506 | 1 | 2019-03-15 13:04:33 | 1 | Metro |
| 7537 | 7518 | 1 | 2019-03-15 13:04:47 | 1 | Metro |
| 7538 | 7495 | 1 | 2019-03-15 13:04:53 | 1 | Metro |
| 7539 | 7499 | 1 | 2019-03-15 13:05:05 | 1 | Metro |
| 7540 | 7496 | 1 | 2019-03-15 13:05:07 | 1 | Metro |
| 7541 | 7516 | 1 | 2019-03-15 13:05:14 | 1 | Metro |
| 7542 | 7523 | 1 | 2019-03-15 13:05:17 | 1 | Metro |
| 7543 | 7498 | 1 | 2019-03-15 13:05:35 | 1 | Metro |
| 7544 | 7510 | 1 | 2019-03-15 13:05:38 | 1 | Metro |
| 7545 | 7502 | 1 | 2019-03-15 13:06:06 | 1 | Metro |
| 7546 | 7524 | 1 | 2019-03-15 13:06:10 | 1 | Metro |
| 7547 | 7505 | 1 | 2019-03-15 13:06:17 | 1 | Metro |
| 7548 | 7521 | 1 | 2019-03-15 13:06:33 | 1 | Metro |
| 7549 | 7509 | 1 | 2019-03-15 13:07:05 | 1 | Metro |
| 7550 | 7508 | 1 | 2019-03-15 13:07:24 | 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;