Skip to content
Louvre Ops DB

Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Download CSV Query in playground

Rows 7,101–7,125 of 9,842

ticket, page 285 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
710130071019324243887
710230071025609093887
710330071034591353887
710430071042562013887
710530071055920163887
710630071065023863887
710730071077864273887
710830071089876953887
710930071097694263887
711030071108439103887
711130071110277563887
711230071126325363887
711330071130792843887
711430071145480083887
711530071158584303887
711630071165943493887
711730071175414103887
711830071188264623887
711930071192092303887
712030071205759953887
712130071217296113887
712230071228757053887
712330071232417813887
712430071247173733887
712530071259880413887
Table definition
CREATE TABLE ticket (
  ticket_id INTEGER PRIMARY KEY,
  barcode   TEXT NOT NULL UNIQUE CHECK (length(barcode) = 13 AND barcode NOT GLOB '*[^0-9]*'),
  order_id  INTEGER NOT NULL REFERENCES purchase_order (order_id)
) STRICT;