This table holds the definition of a ProductSet. The actual representation of the ProductSet is held in the PRSETCEREL table.
Column Name | Column Type | Column Description |
---|---|---|
MARKFORDELETE | INTEGER NOT NULL, DEFAULT 0 |
Indicates if this ProductSet has been marked for deletion: 0 = No. 1 = Marked for deletion. |
MEMBER_ID | BIGINT NOT NULL |
The owner of this ProductSet. |
NAME | VARCHAR (32) NULL |
The name given to this ProductSet. |
PRODUCTSET_ID | INTEGER NOT NULL |
The internal reference number. |
PUBLISHTIME | TIMESTAMP NULL |
The time when this ProductSet was published to the PRSETCEREL table. |
STATIC | CHARACTER (1) NULL |
Indicates whether this ProductSet can be changed. If this column is set to "1", then this PoductSet will never be re-published or synchronized. |
XMLDEFINITION | LONG VARCHAR NULL |
Holds the XML definition of this ProductSet according to the B2BProductSet.dtd. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000191 | NAME, MEMBER_ID | Unique Index |
SQL030416035040200 | PRODUCTSET_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_622 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | 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_864 | PRODUCTSET_ID | TRADEPOSCN | PRODUCTSET_ID | Cascade |
F_921 | PRODUCTSET_ID | PSETADJMNT | PRODUCTSET_ID | Cascade |