Database Table: EMLCFG

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)
Indexes:
Index Name Indexed Column Names Index Type
I0000274 STOREENT_ID, TYPE Unique Index
SQL030416034923400 EMLCFG_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_965 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable