PRODUCTSET

This table holds the definition of a product set. The actual representation of the product set is held in the PRSETCEREL table.

Column Descriptions:

Name	Type	Description
NAME	VARCHAR (32)	The name given to this product set.
PRODUCTSET_ID	INTEGER NOT NULL	The internal reference number.
MEMBER_ID	BIGINT NOT NULL	The owner of this product set.
XMLDEFINITION	CLOB (1000000)	Holds the XML definition of this product set according to the B2BProductSet.dtd.
PUBLISHTIME	TIMESTAMP	The time when this product set was published to the PRSETCEREL table.
MARKFORDELETE	INTEGER NOT NULL DEFAULT 0	Indicates if this product set has been marked for deletion: 0 = No. 1 = Marked for deletion.
STATIC	CHAR (1)	Indicates whether this product set can be changed. If this column is set to 1, then this product set will never be re-published or synchronized.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	PRODUCTSET_ID	Primary Key
I0000191	NAME+MEMBER_ID	Unique Index
I0000700	MEMBER_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_622	MEMBER_ID	MEMBER	MEMBER_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_221	PRODUCTSET_ID	CATGRPPS	PRODUCTSET_ID	Cascade
F_3667	PRODUCTSET_ID	CFPRODUCTSET	PRODUCTSET_ID	Cascade
F_621	PRODUCTSET_ID	PRODSETDSC	PRODUCTSET_ID	Cascade
F_628	PRODUCTSET_ID	PRSETCEREL	PRODUCTSET_ID	Cascade
F_864	PRODUCTSET_ID	TRADEPOSCN	PRODUCTSET_ID	Cascade
F_921	PRODUCTSET_ID	PSETADJMNT	PRODUCTSET_ID	Cascade

Related reference
Contract data model
Product set data model