WebSphere Commerce database table: DKPDCCOMPLIST

Contains the components within a predefined configuration.

Column Descriptions
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

Indexes
Index Name Indexed Column Names Index Type
I0000414 DKPREDEFCONF_ID+CATENTRY_ID Unique Index
SQL060903235151360 DKPDCCOMPLIST_ID Primary Key
I0000413 DKPDCREL_ID Non-Unique Index
I0000908 QTYUNIT_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names 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