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,626–6,650 of 9,738

entry_scan, page 266 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
6626687522018-10-13 12:25:001Metro
6627687722018-10-13 12:25:121Metro
6628687322018-10-13 12:25:171Metro
6629683122018-10-13 13:53:321Bus
6630688042018-10-13 13:59:401Walk
6631688142018-10-13 13:59:431Walk
6632687422018-10-13 15:07:180NULL
6633687532018-10-13 15:30:330NULL
6634687322018-10-13 15:35:250NULL
6635687612018-10-13 16:06:210NULL
6636687722018-10-13 16:09:190NULL
6637684122018-10-14 09:49:111Walk
6638684222018-10-14 09:49:451Walk
6639688242018-10-14 10:04:341Walk
6640688342018-10-14 10:04:361Walk
6641672712018-10-14 12:01:161Metro
6642672812018-10-14 12:01:381Metro
6643688712018-10-15 13:43:571Metro
6644688642018-10-15 15:22:191Walk
6645689142018-10-18 14:09:511Metro
6646684922018-10-18 15:14:211Metro
6647678032018-10-18 15:49:381Bus
6648677932018-10-18 15:49:451Bus
6649689142018-10-18 17:29:460NULL
6650688542018-10-19 15:17:551Walk
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;