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 7,226–7,250 of 9,738

entry_scan, page 290 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
7226757722019-02-01 11:14:091Metro
7227757622019-02-01 11:14:261Metro
7228757922019-02-02 15:51:521Metro
7229758022019-02-02 15:51:581Metro
7230752912019-02-03 11:58:411Walk
7231752712019-02-03 11:58:431Walk
7232753012019-02-03 11:58:491Walk
7233752812019-02-03 11:59:071Walk
7234758732019-02-04 10:55:591Train
7235759042019-02-05 11:57:111Metro
7236758942019-02-05 11:57:191Metro
7237759142019-02-05 11:57:191Metro
7238758942019-02-05 14:36:390NULL
7239759042019-02-05 14:56:050NULL
7240759152019-02-05 15:30:210NULL
7241747512019-02-05 16:31:441Walk
7242747612019-02-05 16:32:191Walk
7243758222019-02-06 10:41:311Walk
7244758522019-02-06 10:41:431Walk
7245758322019-02-06 10:42:031Walk
7246758422019-02-06 10:42:081Walk
7247758852019-02-07 09:31:101Walk
7248757522019-02-07 12:48:341Metro
7249757422019-02-07 12:48:441Metro
7250759422019-02-07 14:30:141Metro
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;