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 4,601–4,625 of 9,842

ticket, page 185 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
460130046015368922557
460230046021420072557
460330046030534692557
460430046044076342557
460530046051105402557
460630046066820222557
460730046072058622557
460830046089762842557
460930046099444252557
461030046106725362557
461130046112147722557
461230046122102002557
461330046139960442557
461430046149317932557
461530046158342262557
461630046167468932557
461730046175738782557
461830046185908432557
461930046196950362557
462030046200243352557
462130046212660112557
462230046228821672557
462330046237644872557
462430046249506102557
462530046253905292557
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;