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,501–7,525 of 9,842

ticket, page 301 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
750130075015160764074
750230075022131684074
750330075037059934074
750430075043602964074
750530075059222844074
750630075063307304074
750730075072085404074
750830075080066904074
750930075093268714074
751030075107404724074
751130075116381484074
751230075127092634074
751330075131126854074
751430075149183684074
751530075159288654074
751630075169656274074
751730075176513124074
751830075183801194074
751930075197893574074
752030075205954844074
752130075213687624074
752230075224568314074
752330075234539504074
752430075241221974074
752530075258489114074
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;