Contains predefined configurations of dynamic kit catalog entries.
Column Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031222350 |
DKPREDEFCONF_ID |
Primary Key |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | 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 |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.