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_


+

Search Tips   |   Advanced Search