Reference > Database > WebSphere Commerce database tables > D


WebSphere Commerce database table: DKPDCCATENTREL

Contains relationships between predefined configurations and the dynamic kit catalog entries for which they are built.

Column Name Column Type Description
DKPREDEFCONF_ID BIGINT NOT NULL The ID of the predefined configuration.
CATENTRY_ID BIGINT NOT NULL The catalog entry ID of the dynamic kit for which this predefined configuration is built.
SEQUENCE INTEGER NOT NULL DEFAULT 0 The sequence number used to determine the order in which to display the component.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030324860 DKPREDEFCONF_ID+CATENTRY_ID Primary Key
I0001255 CATENTRY_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1185 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_1184 DKPREDEFCONF_ID DKPREDEFCONF DKPREDEFCONF_ID Cascade

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search