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 1,351–1,375 of 9,738

entry_scan, page 55 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
1351152422015-11-28 15:39:431Private Vehicle
1352152742015-11-29 10:49:141Walk
1353152822015-11-29 10:59:501Metro
1354152922015-11-29 11:00:221Metro
1355153012015-11-30 12:58:061Walk
1356153112015-11-30 12:58:331Walk
1357153222015-11-30 15:05:491Metro
1358154312015-12-02 14:52:491Metro
1359144142015-12-03 11:36:541Metro
1360154522015-12-03 12:35:491Metro
1361154422015-12-03 12:36:071Metro
1362144142015-12-03 13:24:400NULL
1363153322015-12-03 15:21:191Private Vehicle
1364153422015-12-03 15:21:371Private Vehicle
1365141812015-12-04 09:52:141Taxi
1366141912015-12-04 09:52:331Taxi
1367154912015-12-04 11:05:041Metro
1368155052015-12-04 11:40:511Walk
1369154912015-12-04 12:36:300NULL
1370155122015-12-04 14:36:211Bus
1371155222015-12-04 14:36:241Bus
1372155312015-12-05 11:42:151Metro
1373155412015-12-05 11:42:161Metro
1374155542015-12-06 09:58:591Walk
1375155742015-12-06 09:59:001Walk
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;