This table stores the configuration information about the accounts used in support of e-mail activities. Each store can have one inbound (POP3) and one outbound (SMTP) server configured.
Column Name | Column Type | Description |
---|---|---|
EMLCFG_ID | INTEGER NOT NULL | The primary key. |
NAME | VARCHAR(40) NOT NULL | The name used to refer to this e-mail configuration. |
DESCRIPTION | VARCHAR(254) | The description of the configuration. |
TYPE | INTEGER NOT NULL | The type of server to which the configuration applies. Possible values include: 0 - STMP 1 - POP3 |
HOST | VARCHAR(254) NOT NULL | The hostname of the WebSphere Commerce Server upon which to run the e-mail activity jobs. |
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. |
EMLSERVER | VARCHAR(254) NOT NULL | The hostname of the e-mail server in this configuration (either the POP3 or SMTP server). |
ACCOUNT | VARCHAR(254) NOT NULL | The account name used to connect to the server. |
PORT | INTEGER NOT NULL | The port number to use to connect to the server. |
PASSWORD | BINARY | The password that corresponds to the account used to connect to the server. |
STOREENT_ID | INTEGER NOT NULL | The ID of the store corresponding to the configuration. |
ADDRESS | VARCHAR(254) | When the type of the e-mail configuration is POP3 (that is, when the value in the TYPE column is 1), this is the e-mail address used as the address of the sender. |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000274 | STOREENT_ID+TYPE | Unique Index |
SQL050212031224440 | EMLCFG_ID | Primary Key |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_965 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |