This table holds the definition of a ProductSet. The actual representation of the ProductSet is held in the PRSETCEREL table.
Column Description(s):
Column Name | Column Type | Description |
NAME |
VARCHAR(32) |
The name given to this ProductSet. |
PRODUCTSET_ID |
INTEGER NOT NULL |
The internal reference number. |
MEMBER_ID |
BIGINT NOT NULL |
The owner of this ProductSet. |
XMLDEFINITION |
CLOB |
Holds the XML definition of this ProductSet according to the B2BProductSet.dtd. |
PUBLISHTIME |
TIMESTAMP |
The time when this ProductSet was published to the PRSETCEREL table. |
MARKFORDELETE |
INTEGER NOT NULL DEFAULT 0 |
Indicates if this ProductSet has been marked for deletion:
0 = No.
1 = Marked for deletion. |
STATIC |
CHAR(1) |
Indicates whether this ProductSet can be changed. If this column is set to 1, then this PoductSet will never be re-published or synchronized. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000191 |
NAME+MEMBER_ID |
Unique Index |
SQL050212031258960 |
PRODUCTSET_ID |
Primary Key |
I0000700 |
MEMBER_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_622 |
MEMBER_ID |
MEMBER |
MEMBER_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_221 |
PRODUCTSET_ID |
CATGRPPS |
PRODUCTSET_ID |
Cascade |
F_621 |
PRODUCTSET_ID |
PRODSETDSC |
PRODUCTSET_ID |
Cascade |
F_628 |
PRODUCTSET_ID |
PRSETCEREL |
PRODUCTSET_ID |
Cascade |
F_921 |
PRODUCTSET_ID |
PSETADJMNT |
PRODUCTSET_ID |
Cascade |
F_864 |
PRODUCTSET_ID |
TRADEPOSCN |
PRODUCTSET_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.