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,476–7,500 of 9,842

ticket, page 300 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
747630074765322084073
747730074779414444074
747830074781068404074
747930074796693404074
748030074801838974074
748130074814267224074
748230074826505314074
748330074830502284074
748430074847841224074
748530074858264394074
748630074863080584074
748730074878011954074
748830074883980564074
748930074897132414074
749030074909449814074
749130074914943824074
749230074928860784074
749330074939801194074
749430074943815124074
749530074952938104074
749630074969002674074
749730074978154084074
749830074985485534074
749930074993509004074
750030075009313004074
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;