WebSphere Commerce database table: PRODUCTSET

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


Column Description(s):
Column NameColumn TypeDescription
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 NameIndexed Column NamesIndex Type
I0000191 NAME+MEMBER_ID Unique Index
SQL050212031258960 PRODUCTSET_ID Primary Key
I0000700 MEMBER_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_622 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign 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

Feedback