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 2,701–2,725 of 9,842

ticket, page 109 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
270130027010963351532
270230027026497301532
270330027036759111532
270430027046265791532
270530027056328231532
270630027064227601532
270730027074629101532
270830027083441441532
270930027095794721532
271030027101390281532
271130027116312621532
271230027129807211532
271330027133210081532
271430027141159241532
271530027157023971532
271630027161697541532
271730027171875131532
271830027187574151532
271930027198646091532
272030027206434161532
272130027210959191532
272230027220230701532
272330027236232391532
272430027244276591532
272530027252485251532
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;