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 576–600 of 9,842

ticket, page 24 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
5763000576585633246
5773000577531584246
5783000578000249246
5793000579838124246
5803000580027367246
5813000581498793246
5823000582034050246
5833000583683642246
5843000584109978246
5853000585164641246
5863000586415707246
5873000587625127246
5883000588801565246
5893000589011425246
5903000590032872246
5913000591977741246
5923000592676368246
5933000593997420246
5943000594937279246
5953000595841735246
5963000596857687246
5973000597904482246
5983000598558258247
5993000599641776249
6003000600563681249
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;