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,326–7,350 of 9,842

ticket, page 294 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
732630073260648243993
732730073272110383993
732830073286087113993
732930073291784293994
733030073307601843996
733130073315415643996
733230073320098893997
733330073336512563997
733430073344990913997
733530073357318323998
733630073365564203998
733730073374336713998
733830073388084383998
733930073390400443998
734030073405681994001
734130073415662314001
734230073422003344001
734330073431296734003
734430073448836654004
734530073456572904004
734630073469085774004
734730073479396204004
734830073485684974009
734930073493223274009
735030073508199114009
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;