Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 3,051–3,075 of 9,842

ticket, page 123 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
3051	3003051531936	1729
3052	3003052663297	1730
3053	3003053508781	1732
3054	3003054573085	1732
3055	3003055234971	1734
3056	3003056960782	1734
3057	3003057690324	1734
3058	3003058536379	1734
3059	3003059210230	1735
3060	3003060843562	1735
3061	3003061918525	1737
3062	3003062166678	1737
3063	3003063769522	1740
3064	3003064309258	1740
3065	3003065879879	1740
3066	3003066800719	1740
3067	3003067688045	1744
3068	3003068312832	1746
3069	3003069455960	1747
3070	3003070695505	1747
3071	3003071916057	1747
3072	3003072355202	1747
3073	3003073961171	1750
3074	3003074817444	1750
3075	3003075199971	1751

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;