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,601–6,625 of 9,738

entry_scan, page 265 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
6601684822018-10-09 12:40:181Other
6602684622018-10-09 12:40:251Other
6603684422018-10-09 12:40:471Other
6604684722018-10-09 12:40:571Other
6605684522018-10-09 12:41:001Other
6606686812018-10-09 12:44:081Metro
6607686712018-10-09 12:44:101Metro
6608686612018-10-09 12:44:481Metro
6609670242018-10-09 15:08:511Metro
6610670342018-10-09 15:08:591Metro
6611677322018-10-10 13:16:251Private Vehicle
6612677222018-10-10 13:17:031Private Vehicle
6613678822018-10-10 16:41:541Metro
6614678922018-10-10 16:41:551Metro
6615686912018-10-11 10:56:351Metro
6616650712018-10-11 11:37:251Walk
6617650812018-10-11 11:37:281Walk
6618687112018-10-11 11:43:321Metro
6619687012018-10-11 11:43:451Metro
6620685422018-10-11 13:30:521Other
6621687232018-10-12 09:31:381Walk
6622685712018-10-13 12:08:441Walk
6623685612018-10-13 12:09:041Walk
6624687422018-10-13 12:24:501Metro
6625687622018-10-13 12:24:501Metro
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;