Reference > Database > WebSphere Commerce database tables > D


WebSphere Commerce database table: DKPDCDESC

Contains the descriptions of predefined configurations.

Column Name Column Type Description
DKPREDEFCONF_ID BIGINT NOT NULL The ID of the predefined configuration.
LANGUAGE_ID INTEGER NOT NULL Language in which the name and description are written. For a list of language components, see the LANGUAGE table.
NAME CHAR(128) NOT NULL Name of the predefined configuration.
SHORTDESCRIPTION VARCHAR(254) A short description of the predefined configuration.
LONGDESCRIPTION CLOB The full description of the predefined configuration.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030325170 DKPREDEFCONF_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1186 DKPREDEFCONF_ID DKPREDEFCONF DKPREDEFCONF_ID Cascade
F_1187 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search