Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,076–1,100 of 9,842

ticket, page 44 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1076	3001076489475	622
1077	3001077767351	622
1078	3001078422416	622
1079	3001079679181	622
1080	3001080795968	623
1081	3001081994521	624
1082	3001082577600	624
1083	3001083466335	625
1084	3001084271912	625
1085	3001085514640	625
1086	3001086394227	629
1087	3001087964620	631
1088	3001088001696	631
1089	3001089619561	633
1090	3001090269270	633
1091	3001091433702	634
1092	3001092312559	634
1093	3001093984838	634
1094	3001094872136	634
1095	3001095435170	634
1096	3001096535656	634
1097	3001097081924	634
1098	3001098554350	634
1099	3001099027980	634
1100	3001100262484	634

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;