Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: DKPDCCOMPLIST
Contains the components within a predefined configuration.
Column Name Column Type Description DKPDCCOMPLIST_ID BIGINT NOT NULL The ID of the component in the predefined configuration. 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 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000414 DKPREDEFCONF_ID+CATENTRY_ID Unique Index SQL100520030325040 DKPDCCOMPLIST_ID Primary Key I0000413 DKPDCREL_ID Non-Unique Index I0000908 QTYUNIT_ID Non-Unique Index I0001256 CATENTRY_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 _vcc_freeselect_bottom_