Database Table: EMLPROMO

This table stores e-mail activities. Each row corresponds to an e-mail activity which is sent to a given customer profile.

Column Name Column Type Column Description
DESCRIPTION VARCHAR (254)
NULL
The description of the e-mail activity.
EMLMSG_ID INTEGER
NOT NULL
The e-mail message template to send to the customer profile.
EMLPROMO_ID INTEGER
NOT NULL
The primary key.
MODDATE TIMESTAMP
NULL
The date on which the last modification was performed.
MODIFIEDBY VARCHAR (254)
NULL
The logon ID of the person who last modified the e-mail activity.
NAME VARCHAR (254)
NOT NULL
The name given to the e-mail activity.
SCCJOBREFNUM BIGINT
NOT NULL
The scheduler job created to start sending the e-mail activity.
STATUS INTEGER
NOT NULL, DEFAULT 0
Represents the state of the e-mail activity. (0 - unsent, 1 - sent, 2 - deleted).
STOREENT_ID INTEGER
NOT NULL
The store to which the activity is associated.
Indexes:
Index Name Indexed Column Names Index Type
I0000339 STOREENT_ID Non-Unique Index
SQL030416034924330 EMLPROMO_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_957 EMLMSG_ID EMLMSG EMLMSG_ID Cascade
F_958 STOREENT_ID STOREENT STOREENT_ID Cascade
F_959 SCCJOBREFNUM SCHCONFIG SCCJOBREFNUM Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_960 EMLPROMO_ID EMLRCPTS EMLPROMO_ID Cascade
F_962 EMLPROMO_ID EMLRPTEVTS EMLPROMO_ID Cascade
F_963 EMLPROMO_ID EMLGRPREL EMLPROMO_ID Cascade