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 | 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 | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031225490 | EMLPROMO_ID | Primary Key |
I0000339 | STOREENT_ID | Non-Unique Index |
I0000564 | EMLMSG_ID | Non-Unique Index |
I0000565 | SCCJOBREFNUM | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_957 | EMLMSG_ID | EMLMSG | EMLMSG_ID | Cascade |
F_959 | SCCJOBREFNUM | SCHCONFIG | SCCJOBREFNUM | Cascade |
F_958 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_1034 | EMLPROMO_ID | EMLBOUNCED | EMLPROMO_ID | Cascade |
F_1040 | EMLPROMO_ID | EMLCAMPREL | EMLPROMO_ID | Cascade |
F_963 | EMLPROMO_ID | EMLGRPREL | EMLPROMO_ID | Cascade |
F_960 | EMLPROMO_ID | EMLRCPTS | EMLPROMO_ID | Cascade |
F_962 | EMLPROMO_ID | EMLRPTEVTS | EMLPROMO_ID | Cascade |