WebSphere Commerce database table: PRSETCEREL

This table holds the expanded (published) form of a ProductSet.

Column Descriptions
Column Name Column Type Description
PRODUCTSET_ID INTEGER NOT NULL The ProductSet ID.
CATENTRY_ID BIGINT NOT NULL The CatalogEntry ID.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235237000 PRODUCTSET_ID+CATENTRY_ID Primary Key
I0000702 CATENTRY_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_629 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_628 PRODUCTSET_ID PRODUCTSET PRODUCTSET_ID Cascade
Related reference