Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 3,626–3,650 of 9,842

ticket, page 146 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
3626	3003626868084	1999
3627	3003627369713	1999
3628	3003628817238	1999
3629	3003629064850	2000
3630	3003630669740	2001
3631	3003631966148	2003
3632	3003632344566	2004
3633	3003633071189	2004
3634	3003634929620	2005
3635	3003635207936	2005
3636	3003636815894	2005
3637	3003637642283	2006
3638	3003638527256	2006
3639	3003639138245	2006
3640	3003640036700	2006
3641	3003641118812	2006
3642	3003642456256	2006
3643	3003643411143	2006
3644	3003644416888	2006
3645	3003645661731	2006
3646	3003646507880	2006
3647	3003647642919	2006
3648	3003648129504	2006
3649	3003649274395	2006
3650	3003650535300	2006

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;