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 6,651–6,675 of 9,842

ticket, page 267 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
665130066511066373651
665230066521967793651
665330066538431073651
665430066545825673651
665530066550111163651
665630066564361643651
665730066577257583651
665830066581061033651
665930066592542863651
666030066603172653651
666130066618478783651
666230066622415293651
666330066632505933651
666430066640411113651
666530066659822023651
666630066660728653651
666730066673658843651
666830066689887073651
666930066690508133651
667030066708736683651
667130066717332193651
667230066725007253651
667330066736981603651
667430066744071793651
667530066751901053651
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;