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,876–6,900 of 9,842

ticket, page 276 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
687630068769607623769
687730068778118743769
687830068786024113770
687930068791332973770
688030068803986463771
688130068815573493771
688230068825861283772
688330068836301873772
688430068842050223774
688530068857237523774
688630068861536183775
688730068879203093776
688830068885395303779
688930068899061523781
689030068906892043781
689130068916543123782
689230068925138923784
689330068930867533784
689430068945802643785
689530068958802973785
689630068967102123789
689730068979256643789
689830068980657903791
689930068995691333792
690030069009900433796
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;