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,176–1,200 of 9,738

entry_scan, page 48 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
1176112542015-10-13 13:22:431Bus
1177111542015-10-13 13:23:231Bus
1178111642015-10-13 13:24:261Bus
1179112042015-10-13 13:25:261Bus
1180112342015-10-13 13:26:111Bus
1181131612015-10-13 13:27:271Metro
1182131512015-10-13 13:27:381Metro
1183131742015-10-14 11:43:321Bus
1184131942015-10-14 11:43:321Bus
1185131842015-10-14 11:44:001Bus
1186132412015-10-15 09:40:121Walk
1187132522015-10-15 12:07:001Metro
1188132722015-10-16 11:07:291Metro
1189132622015-10-16 11:07:581Metro
1190132132015-10-16 12:43:201Metro
1191132032015-10-16 12:43:211Metro
1192129512015-10-17 11:38:521Train
1193129612015-10-17 11:39:231Train
1194133122015-10-18 11:02:001Taxi
1195133322015-10-18 13:44:341Metro
1196133222015-10-18 13:44:351Metro
1197133422015-10-18 13:45:141Metro
1198133522015-10-18 13:45:141Metro
1199133522015-10-18 16:28:120NULL
1200133222015-10-18 16:35:580NULL
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;