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,126–8,150 of 9,738

entry_scan, page 326 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
8126830522019-06-02 12:14:220NULL
8127827512019-06-02 13:48:151Walk
8128830422019-06-02 13:55:210NULL
8129830022019-06-02 14:14:301Metro
8130830232019-06-02 15:07:551Walk
8131830332019-06-02 15:08:111Walk
8132827722019-06-02 16:58:111Metro
8133829512019-06-03 10:59:001Walk
8134829612019-06-03 10:59:011Walk
8135828442019-06-03 11:29:041Walk
8136828542019-06-03 11:29:171Walk
8137831912019-06-04 11:26:461Taxi
8138831642019-06-04 11:45:221Walk
8139831542019-06-04 11:45:291Walk
8140831612019-06-04 14:16:150NULL
8141831542019-06-04 15:24:520NULL
8142832012019-06-05 12:09:161Walk
8143832112019-06-05 12:09:261Walk
8144813622019-06-06 11:07:381Metro
8145814022019-06-06 11:07:391Metro
8146813722019-06-06 11:07:531Metro
8147813922019-06-06 11:08:061Metro
8148813822019-06-06 11:08:151Metro
8149813822019-06-06 13:37:560NULL
8150813622019-06-06 13:41:400NULL
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;