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,351–6,375 of 9,842

ticket, page 255 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
635130063510626923510
635230063523331703510
635330063537979383510
635430063543621613511
635530063559947573511
635630063562312173513
635730063570412323514
635830063586255253514
635930063593783873514
636030063608312633514
636130063611246493514
636230063622269603514
636330063630397543514
636430063649001903514
636530063657789073514
636630063664204093514
636730063674860173514
636830063682469493514
636930063698219583514
637030063706365253514
637130063713617483514
637230063727999013514
637330063731078213514
637430063745192753514
637530063752554153514
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;