Skip to content
Louvre Ops DB

Table

entry_scan

Every entrance scan; only the first of the day records how the visitor travelled.

Replaces in 2020: Entrance, Ticket.Transportation

Download CSV Query in playground

Rows 3,651–3,675 of 9,738

entry_scan, page 147 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
3651383322017-04-28 15:24:011Walk
3652383422017-04-28 15:24:091Walk
3653382622017-04-28 15:24:171Metro
3654382722017-04-28 15:24:451Metro
3655382822017-04-28 15:24:551Metro
3656386122017-04-29 09:27:291Metro
3657386422017-04-29 09:27:431Metro
3658386222017-04-29 09:27:461Metro
3659386322017-04-29 09:27:571Metro
3660372222017-04-29 12:24:151Other
3661372122017-04-29 12:24:331Other
3662384922017-04-29 13:11:201Train
3663386622017-04-30 12:25:341Train
3664386522017-04-30 12:26:041Train
3665383032017-05-01 13:58:251Metro
3666382932017-05-01 13:58:531Metro
3667377812017-05-01 14:06:101Walk
3668377712017-05-01 14:06:111Walk
3669387812017-05-02 09:56:401Walk
3670387712017-05-02 09:56:451Walk
3671387912017-05-02 10:22:551Walk
3672387932017-05-02 12:21:140NULL
3673342542017-05-03 11:58:251Bus
3674342642017-05-03 11:58:331Bus
3675342842017-05-03 11:58:331Bus
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;