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 8,001–8,025 of 9,842

ticket, page 321 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
800130080011758264289
800230080020472824289
800330080031822064289
800430080048876274289
800530080052032624289
800630080068131764289
800730080073928804289
800830080089163354289
800930080097299384289
801030080102203174289
801130080114525384289
801230080120843524289
801330080132762084289
801430080140861774289
801530080155465214289
801630080163349794289
801730080178123974289
801830080185231054289
801930080194122834289
802030080207434044289
802130080212231644289
802230080223256894289
802330080237859494289
802430080241740784289
802530080251496894289
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;