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 6,976–7,000 of 9,842

ticket, page 280 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
697630069768549593828
697730069779915913828
697830069788260543828
697930069795525513828
698030069807692903828
698130069811350273828
698230069821771843828
698330069830210053828
698430069843634653828
698530069853955963828
698630069866828753828
698730069879532773828
698830069880216843828
698930069890088733828
699030069904169973828
699130069912214683828
699230069927100383828
699330069932068623828
699430069947085173828
699530069956576513828
699630069966301243828
699730069971285103828
699830069987944353828
699930069994713733828
700030070006801733828
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;