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,251–2,275 of 9,738

entry_scan, page 91 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
2251223912016-06-22 09:36:411Walk
2252233122016-06-23 09:28:091Metro
2253233022016-06-23 09:28:271Metro
2254233222016-06-23 09:28:411Metro
2255233322016-06-23 09:28:571Metro
2256239922016-06-23 13:35:321Metro
2257239822016-06-23 13:35:351Metro
2258240022016-06-23 13:35:521Metro
2259237512016-06-24 09:05:011Walk
2260237612016-06-24 09:05:291Walk
2261240612016-06-24 10:09:121Other
2262234922016-06-24 11:31:191Metro
2263234722016-06-24 11:31:301Metro
2264234622016-06-24 11:31:331Metro
2265235022016-06-24 11:31:391Metro
2266234822016-06-24 11:31:411Metro
2267240512016-06-24 13:17:431Walk
2268240822016-06-24 13:48:111Private Vehicle
2269240722016-06-24 13:48:251Private Vehicle
2270240912016-06-25 13:39:441Walk
2271241012016-06-25 14:11:171Train
2272241522016-06-26 12:02:311Bus
2273241622016-06-26 12:02:371Bus
2274241822016-06-26 12:02:381Bus
2275241722016-06-26 12:02:461Bus
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;