Reference > Database > WebSphere Commerce database tables > E
WebSphere Commerce database table: EMLCFG
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 - POP3HOST 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.
Indexes Index Name Indexed Column Names Index Type I0000274 STOREENT_ID+TYPE Unique Index SQL100520030331690 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 _vcc_freeselect_bottom_