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,076–1,100 of 9,738

entry_scan, page 44 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
1076119722015-09-23 11:37:131Metro
1077119922015-09-23 11:37:201Metro
1078119622015-09-23 11:37:271Metro
1079119822015-09-23 11:37:271Metro
1080120022015-09-23 12:46:521Bus
1081119322015-09-24 10:11:471Walk
1082125312015-09-25 10:32:581Walk
1083125422015-09-25 10:51:321Metro
1084125642015-09-27 10:46:541Walk
1085125742015-09-27 10:46:591Walk
1086125842015-09-27 10:47:061Walk
1087125942015-09-27 10:47:141Walk
1088125542015-09-27 10:47:271Walk
1089126022015-09-27 11:03:431Metro
1090126222015-09-27 12:58:271Metro
1091126122015-09-27 12:58:291Metro
1092112652015-09-27 14:58:001Bus
1093112752015-09-27 14:58:311Bus
1094117732015-09-29 09:47:051Walk
1095127342015-09-30 12:27:141Walk
1096127242015-09-30 12:27:441Walk
1097120112015-10-01 10:01:401Walk
1098127422015-10-01 11:30:281Metro
1099127522015-10-01 11:31:051Metro
1100128312015-10-02 09:16:421Walk
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;