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,051–8,075 of 9,738

entry_scan, page 323 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
8051825912019-05-26 12:31:521Bus
8052825522019-05-26 14:56:171Metro
8053825722019-05-26 14:56:341Metro
8054825822019-05-26 14:56:391Metro
8055825622019-05-26 14:56:471Metro
8056827412019-05-27 10:06:371Metro
8057827312019-05-27 10:06:531Metro
8058824222019-05-27 14:00:421Private Vehicle
8059824322019-05-27 14:00:571Private Vehicle
8060828622019-05-28 10:32:461Metro
8061828722019-05-28 10:33:181Metro
8062828822019-05-28 10:33:191Metro
8063829312019-05-28 13:33:421Metro
8064829212019-05-28 13:34:011Metro
8065829412019-05-28 13:34:061Metro
8066825412019-05-28 14:35:061Train
8067822722019-05-28 15:00:151Train
8068822622019-05-28 15:00:321Train
8069820412019-05-28 16:33:191Walk
8070820312019-05-28 16:33:471Walk
8071828012019-05-30 09:01:561Metro
8072828112019-05-30 09:02:201Metro
8073829742019-05-30 09:49:321Walk
8074828232019-05-31 09:13:451Walk
8075830112019-05-31 10:45:541Metro
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;