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 - deletedMODIFIEDBY 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