Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 3,526–3,550 of 9,842

ticket, page 142 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
3526	3003526708866	1924
3527	3003527606417	1924
3528	3003528123316	1924
3529	3003529307334	1925
3530	3003530391395	1925
3531	3003531740802	1928
3532	3003532633229	1930
3533	3003533946966	1931
3534	3003534361924	1931
3535	3003535348436	1933
3536	3003536055774	1934
3537	3003537569830	1936
3538	3003538681679	1936
3539	3003539633236	1938
3540	3003540793280	1938
3541	3003541604744	1938
3542	3003542227709	1938
3543	3003543510013	1941
3544	3003544609969	1941
3545	3003545625648	1942
3546	3003546159713	1942
3547	3003547444058	1945
3548	3003548708974	1945
3549	3003549417350	1945
3550	3003550762125	1945

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;