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,451–6,475 of 9,842

ticket, page 259 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
645130064512221423557
645230064526961463557
645330064534162923561
645430064548986453564
645530064554769503565
645630064560003333565
645730064577247813565
645830064585645313565
645930064595373933565
646030064608709593566
646130064617883433566
646230064623870273570
646330064633502273570
646430064647913853571
646530064658502083571
646630064668365893572
646730064676172003575
646830064682489303575
646930064690753723577
647030064702689733577
647130064710050783579
647230064729354983579
647330064735354353579
647430064743145693579
647530064755287103580
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;