WebSphere Commerce database table: DKPREDEFCONF

Contains predefined configurations of dynamic kit catalog entries.

Column Descriptions
Column Name Column Type Description
DKPREDEFCONF_ID BIGINT NOT NULL Predefined Configuration ID
CONFIGURATION_ID VARCHAR(256) ID used by external configurator to represent the components of this starting point
COMPLETE SMALLINT NOT NULL DEFAULT 0 This is a flag to specify whether the predefined configuration is complete, or if it requires additional input from an external configurator. The default value, 0, indicates that the predefined configuration is not a complete configuration, and therefore cannot be added to a shopping cart without going through a configurator.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235152070 DKPREDEFCONF_ID Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1184 DKPREDEFCONF_ID DKPDCCATENTREL DKPREDEFCONF_ID Cascade
F_1181 DKPREDEFCONF_ID DKPDCCOMPLIST DKPREDEFCONF_ID Cascade
F_1186 DKPREDEFCONF_ID DKPDCDESC DKPREDEFCONF_ID Cascade
F_1179 DKPREDEFCONF_ID DKPDCOFFERREL DKPREDEFCONF_ID Cascade
F_1075 DKPREDEFCONF_ID DKPDCREL DKPREDEFCONF_ID Cascade