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,951–8,975 of 9,842

ticket, page 359 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
895130089513968084868
895230089526561294868
895330089537080844871
895430089541658274871
895530089552741914871
895630089565435124872
895730089576049954872
895830089584844784872
895930089594103014873
896030089600118884873
896130089619588904873
896230089622906424873
896330089634601874873
896430089642144214873
896530089657867934873
896630089664075924873
896730089676030694873
896830089682914784873
896930089695431564873
897030089700958284873
897130089715729904873
897230089729759034873
897330089730441434873
897430089746713184873
897530089754435974873
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;