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 4,826–4,850 of 9,738

entry_scan, page 194 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
4826492012017-12-07 09:17:491Walk
4827492342017-12-08 11:52:161Metro
4828492142017-12-08 11:52:291Metro
4829492242017-12-08 11:52:541Metro
4830491122017-12-09 10:23:091Metro
4831486342017-12-09 11:58:421Walk
4832486442017-12-09 11:58:441Walk
4833486542017-12-09 11:58:471Walk
4834490612017-12-10 10:54:031Walk
4835492422017-12-10 14:45:371Taxi
4836493122017-12-10 16:23:401Metro
4837492922017-12-10 16:23:421Metro
4838493222017-12-10 16:23:471Metro
4839493022017-12-10 16:23:501Metro
4840492522017-12-12 10:45:171Metro
4841492622017-12-12 10:45:361Metro
4842492722017-12-12 10:45:411Metro
4843493942017-12-12 15:14:581Walk
4844493842017-12-12 15:15:031Walk
4845493642017-12-12 15:15:321Walk
4846493742017-12-12 15:15:331Walk
4847488922017-12-13 10:20:391Train
4848488822017-12-13 10:20:421Train
4849489222017-12-14 10:22:211Metro
4850494632017-12-15 11:52:521Walk
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;