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 2,676–2,700 of 9,842

ticket, page 108 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
267630026765477741521
267730026775456121521
267830026783588841521
267930026795298361521
268030026801145671521
268130026815590901525
268230026827801221526
268330026833663871526
268430026848230411526
268530026858936081528
268630026860380461528
268730026878465281528
268830026886379071528
268930026898903041528
269030026909503541529
269130026916304401529
269230026926490381531
269330026937689011531
269430026947654691532
269530026957866521532
269630026962939181532
269730026978333651532
269830026982610821532
269930026995802881532
270030027004828871532
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;