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 5,176–5,200 of 9,842

ticket, page 208 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
517630051765290882843
517730051779901662843
517830051787317822843
517930051797683922843
518030051808679562843
518130051814437382843
518230051827847692843
518330051832340042843
518430051844882582843
518530051852772362843
518630051860142192843
518730051872497872843
518830051889406372843
518930051896249202843
519030051907535732843
519130051919577622843
519230051926813162843
519330051939528572843
519430051949662672843
519530051951843452843
519630051961440502843
519730051976663002843
519830051981184512843
519930051999804422843
520030052004819322845
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;