DKPDCCATENTREL

Contains relationships between predefined configurations and the dynamic kit catalog entries for which they are built.


Column Descriptions:

Name Type Description
DKPREDEFCONF_ID BIGINT NOT NULL The ID of the predefined configuration.
CATENTRY_ID BIGINT NOT NULL The catalog entry ID of the dynamic kit for which this predefined configuration is built.
SEQUENCE INTEGER NOT NULL DEFAULT 0 The sequence number used to determine the order in which to display the component.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


Indexes:

Name Column Names Type
<SYSTEM-GENERATED> DKPREDEFCONF_ID+CATENTRY_ID Primary Key
I0001255 CATENTRY_ID Non-Unique Index


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_1184 DKPREDEFCONF_ID DKPREDEFCONF DKPREDEFCONF_ID Cascade
F_1185 CATENTRY_ID CATENTRY CATENTRY_ID Cascade