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 276–300 of 9,738

entry_scan, page 12 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
27643142015-05-03 17:29:270NULL
27729422015-05-04 09:23:121Metro
27829522015-05-04 09:23:121Metro
27943522015-05-05 10:29:011Metro
28043922015-05-05 10:29:041Metro
28143622015-05-05 10:29:241Metro
28243722015-05-05 10:29:281Metro
28343822015-05-05 10:29:301Metro
28444022015-05-06 11:57:021Metro
28544122015-05-06 11:57:181Metro
28644312015-05-06 15:24:021Metro
28734612015-05-07 10:45:371Metro
28834712015-05-07 10:45:401Metro
28934412015-05-07 10:45:491Metro
29034312015-05-07 10:45:581Metro
29134512015-05-07 10:45:581Metro
29249952015-05-08 12:45:361Walk
29350052015-05-08 12:45:441Walk
29449852015-05-08 12:45:451Walk
29550152015-05-08 12:46:011Walk
29644222015-05-09 09:39:461Metro
29750432015-05-10 09:37:301Bus
29834022015-05-10 10:06:161Train
29933922015-05-10 10:06:201Train
30050512015-05-10 15:11:201Metro
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;