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 7,701–7,725 of 9,842

ticket, page 309 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
770130077018311004135
770230077025656164135
770330077031044864135
770430077047629244135
770530077051796294135
770630077068917394135
770730077076045094135
770830077087517704135
770930077095391704135
771030077104482294135
771130077112162004135
771230077125421294138
771330077138487334139
771430077148289644139
771530077150909114139
771630077168095354140
771730077178313954140
771830077180426384142
771930077199035604143
772030077207012684146
772130077219519554146
772230077224197404147
772330077237638434147
772430077241137624150
772530077251518834150
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;