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 4,101–4,125 of 9,842

ticket, page 165 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
410130041014889742299
410230041021957842302
410330041034857572302
410430041046188522302
410530041058214812302
410630041067721922302
410730041070951792302
410830041083243802302
410930041098962862302
411030041107847952302
411130041114865422302
411230041121508292302
411330041136923762302
411430041145511452302
411530041156185462302
411630041165363792302
411730041177333812302
411830041188849632302
411930041191509662302
412030041209619332302
412130041219647492302
412230041228749932302
412330041239499032302
412430041244307762302
412530041259758002302
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;