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 8,951–8,975 of 9,738

entry_scan, page 359 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
8951903342019-10-26 09:20:061Metro
8952903042019-10-26 09:20:141Metro
8953903642019-10-26 09:20:211Metro
8954903842019-10-26 09:20:221Metro
8955903742019-10-26 09:20:261Metro
8956903242019-10-26 09:20:421Metro
8957903442019-10-26 09:20:581Metro
8958904542019-10-26 09:21:011Metro
8959904342019-10-26 09:21:041Metro
8960904742019-10-26 09:21:111Metro
8961904042019-10-26 09:21:141Metro
8962904142019-10-26 09:21:221Metro
8963905642019-10-26 09:21:301Metro
8964904842019-10-26 09:21:341Metro
8965903942019-10-26 09:21:361Metro
8966904642019-10-26 09:21:381Metro
8967905942019-10-26 09:21:421Metro
8968905042019-10-26 09:21:461Metro
8969906042019-10-26 09:21:461Metro
8970904442019-10-26 09:22:061Metro
8971905442019-10-26 09:22:101Metro
8972906942019-10-26 09:22:181Metro
8973906542019-10-26 09:22:361Metro
8974905242019-10-26 09:23:041Metro
8975908142019-10-26 09:23:461Metro
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;