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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000339 | STOREENT_ID | Non-Unique Index |
SQL030416034924330 | EMLPROMO_ID | Primary Key |
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 |
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 |