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,976–9,000 of 9,738

entry_scan, page 360 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
8976905142019-10-26 09:23:581Metro
8977905842019-10-26 09:23:581Metro
8978905342019-10-26 09:23:591Metro
8979906842019-10-26 09:24:051Metro
8980907842019-10-26 09:24:161Metro
8981904942019-10-26 09:24:311Metro
8982905742019-10-26 09:24:431Metro
8983907142019-10-26 09:25:061Metro
8984906742019-10-26 09:25:101Metro
8985907642019-10-26 09:25:301Metro
8986906642019-10-26 09:25:361Metro
8987908342019-10-26 09:25:361Metro
8988906142019-10-26 09:25:581Metro
8989905542019-10-26 09:26:011Metro
8990908042019-10-26 09:26:021Metro
8991906242019-10-26 09:26:101Metro
8992907342019-10-26 09:27:171Metro
8993906442019-10-26 09:27:281Metro
8994907742019-10-26 09:27:501Metro
8995908242019-10-26 09:27:561Metro
8996907042019-10-26 09:29:311Metro
8997907442019-10-26 09:30:161Metro
8998907942019-10-26 09:30:301Metro
8999929612019-10-26 10:23:591Metro
9000929712019-10-26 10:24:071Metro
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;