Contains the components within a predefined configuration.
Column Description(s):
Column Name | Column Type | Description |
DKPDCCOMPLIST_ID |
BIGINT NOT NULL |
No DKPDCCOMPLIST_ID external description assigned yet |
DKPREDEFCONF_ID |
BIGINT NOT NULL |
The ID of the predefined configuration. |
CATENTRY_ID |
BIGINT NOT NULL |
The catalog entry of the component within the predefined configuration. |
GROUPNAME |
VARCHAR(254) |
Header name used to group like components for display. |
SEQUENCE |
DOUBLE NOT NULL DEFAULT 0 |
The sequence number used to determine the order in which to display the component. |
QUANTITY |
DOUBLE NOT NULL |
The amount of this component that is in the predefined configuration. |
QTYUNIT_ID |
CHAR(16) |
The unit of measure corresponding to the quantity of the component in the predefined configuration. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
DKPDCREL_ID |
BIGINT |
No DKPDCREL_ID external description assigned yet |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000414 |
DKPREDEFCONF_ID+CATENTRY_ID |
Unique Index |
SQL050212031221720 |
DKPDCCOMPLIST_ID |
Primary Key |
I0000413 |
DKPDCREL_ID |
Non-Unique Index |
I0000908 |
QTYUNIT_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1182 |
CATENTRY_ID |
CATENTRY |
CATENTRY_ID |
Cascade |
F_1062 |
DKPDCREL_ID |
DKPDCREL |
DKPDCREL_ID |
Cascade |
F_1181 |
DKPREDEFCONF_ID |
DKPREDEFCONF |
DKPREDEFCONF_ID |
Cascade |
F_1183 |
QTYUNIT_ID |
QTYUNIT |
QTYUNIT_ID |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.