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 5,626–5,650 of 9,738

entry_scan, page 226 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
5626557622018-05-22 10:55:011Bus
5627557522018-05-22 10:55:041Bus
5628577232018-05-23 10:55:031Metro
5629577132018-05-23 10:55:111Metro
5630576932018-05-23 10:55:171Metro
5631577032018-05-23 10:55:241Metro
5632581012018-05-23 12:19:551Taxi
5633581122018-05-23 14:46:231Metro
5634581222018-05-23 14:46:281Metro
5635578342018-05-24 10:42:381Walk
5636578442018-05-24 10:42:481Walk
5637574412018-05-24 13:42:441Walk
5638574212018-05-24 13:43:181Walk
5639574112018-05-24 13:43:281Walk
5640574312018-05-24 13:43:311Walk
5641581612018-05-24 14:08:591Walk
5642581512018-05-24 14:09:291Walk
5643580952018-05-24 14:13:441Taxi
5644578722018-05-25 10:10:011Metro
5645577412018-05-25 11:54:521Taxi
5646577312018-05-25 11:54:571Taxi
5647580422018-05-25 13:14:551Metro
5648580322018-05-25 13:15:241Metro
5649580522018-05-25 13:15:321Metro
5650580622018-05-25 13:15:421Metro
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;