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,726–8,750 of 9,738

entry_scan, page 350 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
8726887922019-09-04 15:48:061Metro
8727888222019-09-04 15:48:231Metro
8728880012019-09-05 12:08:361Metro
8729879912019-09-05 12:08:391Metro
8730889012019-09-06 10:12:091Metro
8731875352019-09-06 12:43:021Metro
8732875252019-09-06 12:43:341Metro
8733881512019-09-08 10:39:551Metro
8734881612019-09-08 10:39:581Metro
8735890032019-09-08 13:25:571Taxi
8736888422019-09-08 13:31:401Metro
8737888322019-09-08 13:31:511Metro
8738888422019-09-08 16:18:070NULL
8739888332019-09-08 17:10:030NULL
8740888922019-09-10 10:09:251Walk
8741888822019-09-10 10:09:301Walk
8742889812019-09-10 10:47:521Walk
8743889912019-09-10 10:48:041Walk
8744889712019-09-10 10:48:081Walk
8745889512019-09-10 10:48:241Walk
8746889612019-09-10 10:48:311Walk
8747887312019-09-10 11:58:491Walk
8748887412019-09-10 11:59:171Walk
8749888922019-09-10 13:12:290NULL
8750888822019-09-10 13:14:140NULL
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;