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 551–575 of 9,842

ticket, page 23 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
5513000551248334246
5523000552278371246
5533000553382475246
5543000554917660246
5553000555216393246
5563000556867592246
5573000557285253246
5583000558816654246
5593000559600048246
5603000560917869246
5613000561797149246
5623000562754097246
5633000563484815246
5643000564075869246
5653000565186520246
5663000566134782246
5673000567218523246
5683000568935338246
5693000569331916246
5703000570105440246
5713000571915857246
5723000572720195246
5733000573856226246
5743000574634126246
5753000575653556246
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;