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 6,501–6,525 of 9,738

entry_scan, page 261 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
6501674612018-09-23 14:00:201Train
6502674712018-09-23 14:00:251Train
6503675212018-09-24 13:47:251Metro
6504675622018-09-25 10:39:411Metro
6505675522018-09-25 10:39:481Metro
6506675822018-09-25 10:39:531Metro
6507675722018-09-25 10:40:021Metro
6508675922018-09-25 10:40:111Metro
6509674342018-09-25 10:54:511Walk
6510674242018-09-25 10:54:521Walk
6511676022018-09-25 12:53:531Walk
6512676122018-09-25 14:46:121Train
6513676222018-09-25 14:46:271Train
6514676642018-09-26 09:00:231Walk
6515676942018-09-26 09:00:311Walk
6516676842018-09-26 09:00:391Walk
6517676742018-09-26 09:00:541Walk
6518676442018-09-26 09:34:351Walk
6519676542018-09-26 09:35:001Walk
6520675122018-09-26 10:41:241Walk
6521675022018-09-26 10:41:261Walk
6522674922018-09-26 10:41:501Walk
6523677022018-09-26 11:25:261Metro
6524673922018-09-26 12:25:381Private Vehicle
6525662422018-09-27 10:50:091Private Vehicle
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;