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,601–6,625 of 9,842

ticket, page 265 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
660130066019319203635
660230066021897103636
660330066039348663636
660430066043076193637
660530066055303803637
660630066060581423637
660730066079461203637
660830066083069893637
660930066097491673639
661030066105043483639
661130066116048803640
661230066126474963640
661330066136743363642
661430066141604883643
661530066156031263643
661630066163042573644
661730066178410493644
661830066185923093645
661930066194155873648
662030066209458373648
662130066218294683650
662230066225904443650
662330066231853303650
662430066247056353650
662530066256911183651
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;