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 1,926–1,950 of 9,738

entry_scan, page 78 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
1926204322016-04-10 15:03:171Walk
1927204622016-04-10 15:03:211Walk
1928204522016-04-10 15:03:571Walk
1929205812016-04-14 11:29:381Metro
1930205712016-04-14 11:30:041Metro
1931206222016-04-14 13:44:451Metro
1932205922016-04-14 13:45:021Metro
1933206022016-04-14 13:45:051Metro
1934206122016-04-14 13:45:121Metro
1935203822016-04-15 11:05:501Bus
1936203522016-04-15 11:05:541Bus
1937203722016-04-15 11:06:181Bus
1938203622016-04-15 11:06:321Bus
1939202612016-04-15 11:57:291Bus
1940202512016-04-15 11:57:341Bus
1941202712016-04-15 11:57:511Bus
1942204942016-04-16 10:10:261Walk
1943204842016-04-16 10:10:271Walk
1944206322016-04-16 12:55:141Walk
1945206422016-04-16 12:55:191Walk
1946206512016-04-16 15:42:041Metro
1947206912016-04-17 10:09:291Other
1948206812016-04-17 10:09:331Other
1949207122016-04-19 09:03:431Metro
1950207012016-04-19 10:18:281Metro
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;