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:

NameTypeDescription
NAMEVARCHAR (32)The name given to this product set.
PRODUCTSET_IDINTEGER NOT NULLThe internal reference number.
MEMBER_IDBIGINT NOT NULLThe owner of this product set.
XMLDEFINITIONCLOB (1000000)Holds the XML definition of this product set according to the B2BProductSet.dtd.
PUBLISHTIMETIMESTAMPThe time when this product set was published to the PRSETCEREL table.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Indicates if this product set has been marked for deletion: 0 = No. 1 = Marked for deletion.
STATICCHAR (1)Indicates whether this product set can be changed. If this column is set to 1, then this poduct set will never be re-published or synchronized.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PRODUCTSET_IDPrimary Key
I0000191NAME+MEMBER_IDUnique Index
I0000700MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_622MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_221PRODUCTSET_IDCATGRPPSPRODUCTSET_IDCascade
F_3667PRODUCTSET_IDCFPRODUCTSETPRODUCTSET_IDCascade
F_621PRODUCTSET_IDPRODSETDSCPRODUCTSET_IDCascade
F_628PRODUCTSET_IDPRSETCERELPRODUCTSET_IDCascade
F_864PRODUCTSET_IDTRADEPOSCNPRODUCTSET_IDCascade
F_921PRODUCTSET_IDPSETADJMNTPRODUCTSET_IDCascade