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,526–6,550 of 9,842

ticket, page 262 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
652630065266772393608
652730065274511413608
652830065281713173608
652930065296480803608
653030065307370053608
653130065316721873608
653230065327699303608
653330065335873913608
653430065349122423608
653530065357308093608
653630065362852903608
653730065378077103608
653830065389285923608
653930065396292893608
654030065400591283608
654130065414332383608
654230065423390013608
654330065438640263608
654430065448989513608
654530065452959403608
654630065468719473608
654730065477175283608
654830065481209413608
654930065495070023608
655030065503236703608
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;