Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 2,001–2,025 of 9,842

ticket, page 81 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
2001	3002001571334	1095
2002	3002002317028	1095
2003	3002003963590	1095
2004	3002004943761	1095
2005	3002005999685	1095
2006	3002006121434	1097
2007	3002007162205	1099
2008	3002008150301	1100
2009	3002009283350	1100
2010	3002010718313	1100
2011	3002011955448	1100
2012	3002012071967	1101
2013	3002013797728	1103
2014	3002014790481	1103
2015	3002015384371	1103
2016	3002016816740	1103
2017	3002017114797	1103
2018	3002018972840	1104
2019	3002019078090	1104
2020	3002020472759	1104
2021	3002021283488	1105
2022	3002022321332	1105
2023	3002023088647	1109
2024	3002024714416	1109
2025	3002025942641	1115

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;