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,451–2,475 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 2451 | 2539 | 1 | 2016-07-22 13:26:15 | 1 | Walk |
| 2452 | 2540 | 1 | 2016-07-22 13:26:17 | 1 | Walk |
| 2453 | 2549 | 3 | 2016-07-23 14:35:44 | 1 | Metro |
| 2454 | 2548 | 3 | 2016-07-23 14:36:06 | 1 | Metro |
| 2455 | 2450 | 2 | 2016-07-24 09:57:11 | 1 | Private Vehicle |
| 2456 | 2522 | 2 | 2016-07-24 11:04:50 | 1 | Private Vehicle |
| 2457 | 2546 | 2 | 2016-07-25 10:42:43 | 1 | Metro |
| 2458 | 2545 | 2 | 2016-07-25 10:42:56 | 1 | Metro |
| 2459 | 2457 | 2 | 2016-07-25 11:36:07 | 1 | Metro |
| 2460 | 2546 | 2 | 2016-07-25 12:13:06 | 0 | NULL |
| 2461 | 2545 | 3 | 2016-07-25 13:47:47 | 0 | NULL |
| 2462 | 2527 | 5 | 2016-07-26 14:29:06 | 1 | Walk |
| 2463 | 2524 | 5 | 2016-07-26 14:29:10 | 1 | Walk |
| 2464 | 2526 | 5 | 2016-07-26 14:29:28 | 1 | Walk |
| 2465 | 2523 | 5 | 2016-07-26 14:29:44 | 1 | Walk |
| 2466 | 2525 | 5 | 2016-07-26 14:29:50 | 1 | Walk |
| 2467 | 2561 | 1 | 2016-07-26 15:32:17 | 1 | Walk |
| 2468 | 2562 | 1 | 2016-07-27 09:56:31 | 1 | Walk |
| 2469 | 2563 | 1 | 2016-07-27 10:55:42 | 1 | Walk |
| 2470 | 2555 | 1 | 2016-07-27 11:53:58 | 1 | Walk |
| 2471 | 2556 | 1 | 2016-07-27 11:54:32 | 1 | Walk |
| 2472 | 2518 | 2 | 2016-07-27 13:17:30 | 1 | Train |
| 2473 | 2517 | 2 | 2016-07-27 13:17:32 | 1 | Train |
| 2474 | 2516 | 2 | 2016-07-27 13:18:02 | 1 | Train |
| 2475 | 2562 | 5 | 2016-07-27 13:31:28 | 0 | NULL |
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;