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

ticket, page 148 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
367630036769550002006
367730036774263802006
367830036786768302006
367930036795094142006
368030036803924332006
368130036817174122007
368230036827451632007
368330036833954332008
368430036841142612008
368530036854866582010
368630036862017132010
368730036870063412012
368830036885548172012
368930036899175192013
369030036907172732014
369130036918247572015
369230036922841272016
369330036939437892021
369430036940692252024
369530036956087202025
369630036961350212025
369730036970585182026
369830036985728052026
369930036993577652026
370030037005515552026
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;