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

entry_scan, page 106 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
2626274122016-08-26 09:53:241Metro
2627274022016-08-26 09:54:011Metro
2628274612016-08-26 11:59:001Metro
2629274512016-08-26 11:59:101Metro
2630265612016-08-26 14:32:161Metro
2631265712016-08-26 14:32:261Metro
2632274722016-08-27 10:13:091Metro
2633274912016-08-28 10:19:581Walk
2634274812016-08-28 10:20:321Walk
2635275242016-08-28 11:24:451Walk
2636275012016-08-29 09:52:211Walk
2637275112016-08-29 09:52:361Walk
2638275322016-08-29 11:41:401Metro
2639275422016-08-29 11:41:411Metro
2640266612016-08-29 15:07:551Metro
2641266512016-08-29 15:08:081Metro
2642268122016-08-30 09:03:491Metro
2643276622016-08-31 13:19:271Metro
2644276812016-08-31 13:48:231Metro
2645276712016-08-31 13:48:291Metro
2646276922016-09-01 09:38:421Taxi
2647277422016-09-01 11:00:381Metro
2648277622016-09-01 11:00:481Metro
2649277522016-09-01 11:00:501Metro
2650278042016-09-02 11:16:111Other
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;