Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 2,501–2,525 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 2501 | 2547 | 1 | 2016-08-02 09:47:53 | 1 | Metro |
| 2502 | 2583 | 1 | 2016-08-02 13:41:00 | 1 | Metro |
| 2503 | 2569 | 2 | 2016-08-02 15:17:40 | 1 | Metro |
| 2504 | 2568 | 2 | 2016-08-02 15:17:43 | 1 | Metro |
| 2505 | 2541 | 5 | 2016-08-03 09:22:49 | 1 | Walk |
| 2506 | 2533 | 1 | 2016-08-04 11:36:55 | 1 | Taxi |
| 2507 | 2532 | 1 | 2016-08-04 11:37:04 | 1 | Taxi |
| 2508 | 2595 | 1 | 2016-08-05 12:16:09 | 1 | Bus |
| 2509 | 2594 | 1 | 2016-08-05 12:16:15 | 1 | Bus |
| 2510 | 2601 | 1 | 2016-08-06 09:54:44 | 1 | Walk |
| 2511 | 2599 | 1 | 2016-08-06 09:55:07 | 1 | Walk |
| 2512 | 2598 | 1 | 2016-08-06 09:55:16 | 1 | Walk |
| 2513 | 2600 | 1 | 2016-08-06 09:55:23 | 1 | Walk |
| 2514 | 2602 | 1 | 2016-08-06 14:40:23 | 1 | Metro |
| 2515 | 2574 | 5 | 2016-08-07 09:52:36 | 1 | Walk |
| 2516 | 2573 | 5 | 2016-08-07 09:52:39 | 1 | Walk |
| 2517 | 2572 | 5 | 2016-08-07 09:52:41 | 1 | Walk |
| 2518 | 2587 | 2 | 2016-08-07 09:56:03 | 1 | Metro |
| 2519 | 2588 | 2 | 2016-08-07 09:56:09 | 1 | Metro |
| 2520 | 2608 | 1 | 2016-08-07 12:16:52 | 1 | Bus |
| 2521 | 2609 | 1 | 2016-08-07 12:17:11 | 1 | Bus |
| 2522 | 2607 | 1 | 2016-08-07 12:17:20 | 1 | Bus |
| 2523 | 2606 | 1 | 2016-08-07 12:17:23 | 1 | Bus |
| 2524 | 2559 | 2 | 2016-08-08 10:40:19 | 1 | Metro |
| 2525 | 2605 | 4 | 2016-08-09 12:26:55 | 1 | Walk |
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;