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 4,201–4,225 of 9,738

entry_scan, page 169 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
4201437622017-08-12 11:04:481Metro
4202430022017-08-12 11:46:171Private Vehicle
4203433912017-08-13 10:32:311Metro
4204433812017-08-13 10:32:351Metro
4205434012017-08-13 10:32:481Metro
4206437422017-08-13 11:29:261Metro
4207437422017-08-13 13:19:560NULL
4208434212017-08-13 13:40:581Metro
4209434112017-08-13 13:41:311Metro
4210438112017-08-13 16:47:271Bus
4211438412017-08-14 09:24:511Other
4212438212017-08-14 09:26:271Metro
4213438312017-08-14 09:26:441Metro
4214438532017-08-14 13:13:301Metro
4215438622017-08-14 14:33:431Metro
4216438822017-08-14 14:34:041Metro
4217438922017-08-14 14:34:121Metro
4218438722017-08-14 14:34:131Metro
4219439522017-08-15 09:53:081Bus
4220439422017-08-15 09:53:251Bus
4221434532017-08-16 09:23:041Walk
4222434432017-08-16 09:23:291Walk
4223440012017-08-16 09:25:561Metro
4224440012017-08-16 12:38:580NULL
4225430832017-08-16 14:36:211Walk
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;