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 5,701–5,725 of 9,842

ticket, page 229 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
570130057016557613186
570230057027606843187
570330057038506413187
570430057042794613188
570530057059866043189
570630057065428293190
570730057070247763191
570830057089093393191
570930057094448293191
571030057108486683191
571130057119200423191
571230057123561093191
571330057133850953191
571430057148998073191
571530057150819873191
571630057161337943191
571730057178020803191
571830057186381953191
571930057198106513191
572030057209347703191
572130057218508983191
572230057227506893191
572330057237482183191
572430057249153693191
572530057254568143191
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;