Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 526–550 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 526 | 723 | 4 | 2015-06-28 10:43:22 | 1 | Walk |
| 527 | 722 | 4 | 2015-06-28 10:43:29 | 1 | Walk |
| 528 | 725 | 3 | 2015-06-28 11:38:19 | 1 | Walk |
| 529 | 726 | 1 | 2015-06-28 12:30:10 | 1 | Bus |
| 530 | 727 | 1 | 2015-06-28 13:34:14 | 1 | Walk |
| 531 | 172 | 1 | 2015-06-30 13:46:01 | 1 | Bus |
| 532 | 173 | 1 | 2015-06-30 13:46:15 | 1 | Bus |
| 533 | 176 | 1 | 2015-06-30 13:46:17 | 1 | Bus |
| 534 | 174 | 1 | 2015-06-30 13:46:29 | 1 | Bus |
| 535 | 179 | 1 | 2015-06-30 13:46:29 | 1 | Bus |
| 536 | 175 | 1 | 2015-06-30 13:46:34 | 1 | Bus |
| 537 | 181 | 1 | 2015-06-30 13:46:37 | 1 | Bus |
| 538 | 178 | 1 | 2015-06-30 13:47:01 | 1 | Bus |
| 539 | 191 | 1 | 2015-06-30 13:47:09 | 1 | Bus |
| 540 | 177 | 1 | 2015-06-30 13:47:11 | 1 | Bus |
| 541 | 183 | 1 | 2015-06-30 13:47:11 | 1 | Bus |
| 542 | 180 | 1 | 2015-06-30 13:47:21 | 1 | Bus |
| 543 | 196 | 1 | 2015-06-30 13:47:51 | 1 | Bus |
| 544 | 190 | 1 | 2015-06-30 13:47:53 | 1 | Bus |
| 545 | 199 | 1 | 2015-06-30 13:48:06 | 1 | Bus |
| 546 | 187 | 1 | 2015-06-30 13:48:11 | 1 | Bus |
| 547 | 184 | 1 | 2015-06-30 13:48:24 | 1 | Bus |
| 548 | 198 | 1 | 2015-06-30 13:48:25 | 1 | Bus |
| 549 | 185 | 1 | 2015-06-30 13:48:37 | 1 | Bus |
| 550 | 200 | 1 | 2015-06-30 13:48:37 | 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;