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

entry_scan, page 186 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
4626413612017-10-26 12:32:281Bus
4627481022017-10-28 09:56:001Other
4628478912017-10-28 10:37:441Metro
4629478712017-10-28 10:38:161Metro
4630478812017-10-28 10:38:221Metro
4631479122017-10-28 10:40:521Metro
4632479322017-10-28 10:40:571Metro
4633479222017-10-28 10:41:221Metro
4634479022017-10-28 10:41:331Metro
4635474922017-10-28 14:50:341Bus
4636483032017-10-30 10:25:061Walk
4637482932017-10-30 10:25:341Walk
4638483132017-10-30 10:25:411Walk
4639482832017-10-30 10:25:431Walk
4640478112017-10-30 11:39:281Walk
4641483452017-10-31 10:33:141Walk
4642483252017-10-31 10:33:151Walk
4643483352017-10-31 10:33:241Walk
4644482222017-11-02 10:55:221Metro
4645482322017-11-02 10:55:231Metro
4646481522017-11-04 10:04:141Metro
4647481622017-11-04 10:04:361Metro
4648482132017-11-04 12:00:421Metro
4649481932017-11-04 12:01:121Metro
4650482032017-11-04 12:01:141Metro
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;