WebSphere Commerce database table: DKPDCCOMPLIST

Contains the components within a predefined configuration.


Column Description(s):
Column NameColumn TypeDescription
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 NameIndexed Column NamesIndex 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 NameColumn Name(s)Foreign Table NameForeign 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

Feedback