EMLSTRPLCY

Stores the relationship between a store and a bounced e-mail retry policy.


Column Descriptions:

Name 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 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> EMLPOLICY_ID Primary Key
I0000383 STOREENT_ID Non-Unique Index


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_1037 EMLPOLICY_ID EMLPOLICY EMLPOLICY_ID Cascade
F_1039 STOREENT_ID STOREENT STOREENT_ID Cascade