Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 5,526–5,550 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 5526 | 5385 | 4 | 2018-05-07 11:55:31 | 1 | Bus |
| 5527 | 5391 | 4 | 2018-05-07 11:55:37 | 1 | Bus |
| 5528 | 5389 | 4 | 2018-05-07 11:55:55 | 1 | Bus |
| 5529 | 5395 | 4 | 2018-05-07 11:55:55 | 1 | Bus |
| 5530 | 5406 | 4 | 2018-05-07 11:55:56 | 1 | Bus |
| 5531 | 5414 | 4 | 2018-05-07 11:55:59 | 1 | Bus |
| 5532 | 5397 | 4 | 2018-05-07 11:56:11 | 1 | Bus |
| 5533 | 5418 | 4 | 2018-05-07 11:56:15 | 1 | Bus |
| 5534 | 5411 | 4 | 2018-05-07 11:56:21 | 1 | Bus |
| 5535 | 5412 | 4 | 2018-05-07 11:56:26 | 1 | Bus |
| 5536 | 5399 | 4 | 2018-05-07 11:56:27 | 1 | Bus |
| 5537 | 5392 | 4 | 2018-05-07 11:56:31 | 1 | Bus |
| 5538 | 5413 | 4 | 2018-05-07 11:56:31 | 1 | Bus |
| 5539 | 5423 | 4 | 2018-05-07 11:56:35 | 1 | Bus |
| 5540 | 5408 | 4 | 2018-05-07 11:56:37 | 1 | Bus |
| 5541 | 5415 | 4 | 2018-05-07 11:56:41 | 1 | Bus |
| 5542 | 5401 | 4 | 2018-05-07 11:57:31 | 1 | Bus |
| 5543 | 5407 | 4 | 2018-05-07 11:57:31 | 1 | Bus |
| 5544 | 5405 | 4 | 2018-05-07 11:57:43 | 1 | Bus |
| 5545 | 5419 | 4 | 2018-05-07 11:57:43 | 1 | Bus |
| 5546 | 5422 | 4 | 2018-05-07 11:58:01 | 1 | Bus |
| 5547 | 5400 | 4 | 2018-05-07 11:58:07 | 1 | Bus |
| 5548 | 5396 | 4 | 2018-05-07 11:58:16 | 1 | Bus |
| 5549 | 5424 | 4 | 2018-05-07 11:59:00 | 1 | Bus |
| 5550 | 5403 | 4 | 2018-05-07 11:59:09 | 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;