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,201–7,225 of 9,842

ticket, page 289 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
720130072016254633913
720230072029250693914
720330072033633353915
720430072048290733918
720530072054231453920
720630072069054833920
720730072076345853920
720830072080725303922
720930072093011293922
721030072107996593923
721130072110404013923
721230072121711863925
721330072138685753925
721430072143752413926
721530072152921983927
721630072161858523927
721730072173520893928
721830072187176103928
721930072193815613932
722030072205278723932
722130072210860693933
722230072222492673933
722330072231571613936
722430072244196503939
722530072252782773941
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;