WebSphere Commerce database table: DKPDCOFFERREL

WebSphere Commerce database table: DKPDCOFFERREL

Contains relationships between predefined configurations and the offers that price them.
Column Descriptions
Column Name Column Type Description
DKPREDEFCONF_ID BIGINT NOT NULL The ID of the predefined configuration.
OFFER_ID BIGINT NOT NULL The offer ID assigned to the predefined configuration.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235151730 DKPREDEFCONF_ID Primary Key
I0000917 OFFER_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1179 DKPREDEFCONF_ID DKPREDEFCONF DKPREDEFCONF_ID Cascade
F_1180 OFFER_ID OFFER OFFER_ID Cascade

Column Name	Column Type	Description
DKPREDEFCONF_ID	BIGINT NOT NULL	The ID of the predefined configuration.
OFFER_ID	BIGINT NOT NULL	The offer ID assigned to the predefined configuration.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Index Name	Indexed Column Names	Index Type
SQL060903235151730	DKPREDEFCONF_ID	Primary Key
I0000917	OFFER_ID	Non-Unique Index

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1179	DKPREDEFCONF_ID	DKPREDEFCONF	DKPREDEFCONF_ID	Cascade
F_1180	OFFER_ID	OFFER	OFFER_ID	Cascade