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 6,451–6,475 of 9,738

entry_scan, page 259 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
6451670522018-09-14 10:56:081Metro
6452670622018-09-14 10:56:141Metro
6453670722018-09-14 10:56:221Metro
6454670422018-09-14 10:56:351Metro
6455671052018-09-15 09:36:281Walk
6456671112018-09-15 10:52:351Other
6457671212018-09-15 10:53:041Other
6458671542018-09-16 12:02:111Metro
6459671442018-09-16 12:02:311Metro
6460671342018-09-16 12:02:471Metro
6461671912018-09-16 15:08:281Walk
6462671812018-09-16 15:09:111Walk
6463671542018-09-16 15:24:060NULL
6464671312018-09-16 15:35:230NULL
6465671442018-09-16 15:49:430NULL
6466672012018-09-17 10:13:511Bus
6467672222018-09-17 11:16:571Metro
6468672322018-09-17 11:17:101Metro
6469672122018-09-17 11:17:161Metro
6470672422018-09-17 11:17:301Metro
6471672522018-09-17 11:21:151Bus
6472672622018-09-17 11:21:271Bus
6473668712018-09-18 10:58:421Train
6474668612018-09-18 10:59:151Train
6475670912018-09-18 11:42:091Walk
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;