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,751–3,775 of 9,842

ticket, page 151 of 394
ticket_idINTEGERbarcodeTEXTorder_id→ purchase_order.order_id
375130037518036142058
375230037527674142058
375330037536111312059
375430037548151642059
375530037550896892059
375630037560659902059
375730037572429402060
375830037580534732062
375930037591495972063
376030037606268552063
376130037614936922066
376230037622659052067
376330037636766162067
376430037640456092067
376530037650242962067
376630037665360222069
376730037675543312070
376830037681500102070
376930037698913892070
377030037708162812070
377130037716812232071
377230037725705052074
377330037731456232074
377430037743749292074
377530037755897512074
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;