This table stores the configuration of e-mail activity accounts. Each store can have one inbound (POP3) and one outbound (SMTP) server configured.
Column Name | Column Type | Column Description |
---|---|---|
ACCOUNT | VARCHAR (254) NOT NULL |
The account name used to connect to the server. |
ADDRESS | VARCHAR (254) NULL |
The e-mail address for the account. |
DESCRIPTION | VARCHAR (254) NULL |
The description of the configuration. |
EMLCFG_ID | INTEGER NOT NULL |
The primary key. |
EMLSERVER | VARCHAR (254) NOT NULL |
The hostname of the e-mail server in this configuration (either the POP3 or SMTP server). |
HOST | VARCHAR (254) NOT NULL |
The hostname of the commerce server upon which to run the e-mail activity jobs. |
NAME | VARCHAR (40) NOT NULL |
The name used to refer to this e-mail configuration. |
PASSWORD | CHARACTER (128) NULL |
The password used to the connect to the server. If this is left null for an SMTP server, it is interpreted that the server does not require authentication, otherwise the password will be used to authenticate with the server. |
PORT | INTEGER NOT NULL |
The port number with which to connect to the server. |
STOREENT_ID | INTEGER NOT NULL |
The store corresponding to the configuration. |
TIME | INTEGER NOT NULL |
The number of minutes past 12:00am upon which to run the e-mail activity jobs. This value is only stored for reference. The actual time the e-mail activity will be sent is stored in the SCHCONFIG table. |
TYPE | INTEGER NOT NULL |
The type of server configured. (0 - STMP, 1 - POP3) |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000274 | STOREENT_ID, TYPE | Unique Index |
SQL030416034923400 | EMLCFG_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_965 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|