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,401–6,425 of 9,842

ticket, page 257 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
640130064011212963525
640230064026120403526
640330064038923073527
640430064046206713527
640530064051719743530
640630064064811583530
640730064073804363532
640830064088828563534
640930064097419303534
641030064105194553535
641130064111993953535
641230064125221733535
641330064135770963537
641430064143271913537
641530064159439133538
641630064162380763539
641730064178598023539
641830064189148643542
641930064192789323542
642030064209061653542
642130064211781373542
642230064224587183542
642330064235102203543
642430064248499953543
642530064250568893544
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;