EMLPROMO

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

Column Descriptions:

Name	Type	Description
EMLPROMO_ID	INTEGER NOT NULL	The primary key.
STATUS	INTEGER NOT NULL DEFAULT 0	Represents the current state of the e-mail activity. Possible values include: 0 - unsent 1 - sent 2 - deleted
MODIFIEDBY	VARCHAR (254)	The logon ID of the person who last modified the e-mail activity.
MODDATE	TIMESTAMP	The date on which the last modification was performed.
DESCRIPTION	VARCHAR (254)	The description of the e-mail activity.
NAME	VARCHAR (254) NOT NULL	The name given to the e-mail activity.
EMLMSG_ID	INTEGER NOT NULL	The e-mail message template to send to the target customer segment.
STOREENT_ID	INTEGER NOT NULL	The ID of the store with which the e-mail activity is associated.
SCCJOBREFNUM	BIGINT NOT NULL	Foreign key to SCHCONFIG table.
REPLYTO	VARCHAR (256)	The reply-to e-mail address for the e-mail activity.
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>	EMLPROMO_ID	Primary Key
I0000339	STOREENT_ID	Non-Unique Index
I0000564	EMLMSG_ID	Non-Unique Index
I0000565	SCCJOBREFNUM	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	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 Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_1034	EMLPROMO_ID	EMLBOUNCED	EMLPROMO_ID	Cascade
F_1040	EMLPROMO_ID	EMLCAMPREL	EMLPROMO_ID	Cascade
F_960	EMLPROMO_ID	EMLRCPTS	EMLPROMO_ID	Cascade
F_962	EMLPROMO_ID	EMLRPTEVTS	EMLPROMO_ID	Cascade
F_963	EMLPROMO_ID	EMLGRPREL	EMLPROMO_ID	Cascade