WebSphere Commerce database table: EMLSTRPLCY

WebSphere Commerce database table: EMLSTRPLCY

Stores the relationship between a store and a bounced e-mail retry policy.
Column Descriptions
Column Name Column Type Description
EMLPOLICY_ID INTEGER NOT NULL Reference to the EMLPOLICY_ID in the EMLPOLICY table.
STOREENT_ID INTEGER NOT NULL Reference to the STOREENT_ID in the STORE table.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235156010 EMLPOLICY_ID Primary Key
I0000383 STOREENT_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1037 EMLPOLICY_ID EMLPOLICY EMLPOLICY_ID Cascade
F_1039 STOREENT_ID STOREENT STOREENT_ID Cascade

Column Name	Column Type	Description
EMLPOLICY_ID	INTEGER NOT NULL	Reference to the EMLPOLICY_ID in the EMLPOLICY table.
STOREENT_ID	INTEGER NOT NULL	Reference to the STOREENT_ID in the STORE table.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Index Name	Indexed Column Names	Index Type
SQL060903235156010	EMLPOLICY_ID	Primary Key
I0000383	STOREENT_ID	Non-Unique Index

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1037	EMLPOLICY_ID	EMLPOLICY	EMLPOLICY_ID	Cascade
F_1039	STOREENT_ID	STOREENT	STOREENT_ID	Cascade