Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PRODUCTSET
This table holds the definition of a product set. The actual representation of the product set is held in the PRSETCEREL table.
Column Name Column 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 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 poduct set will never be re-published or synchronized. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000191 NAME+MEMBER_ID Unique Index SQL100520030414280 PRODUCTSET_ID Primary Key I0000700 MEMBER_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_622 MEMBER_ID MEMBER MEMBER_ID Cascade
Referenced By 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_921 PRODUCTSET_ID PSETADJMNT PRODUCTSET_ID Cascade F_864 PRODUCTSET_ID TRADEPOSCN PRODUCTSET_ID Cascade
Related reference
_vcc_freeselect_bottom_