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

ticket, page 319 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
795130079512830374263
795230079523518234263
795330079533282734263
795430079541487674263
795530079555107624263
795630079563189114263
795730079578197294263
795830079586060914263
795930079594418584263
796030079600817264263
796130079617748614263
796230079629868094263
796330079633454994263
796430079649946434263
796530079654442524263
796630079664898204263
796730079673867454263
796830079686532384263
796930079690645264263
797030079708301424263
797130079716363794263
797230079724189524263
797330079738968984264
797430079747692464264
797530079750847994265
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;