Reference > Database > WebSphere Commerce database tables > E
WebSphere Commerce database table: EMLBADADDR
This table records information about users with invalid e-mail addresses. Each row corresponds to a user that has an invalid e-mail address.
Column Name Column Type Description USERS_ID BIGINT NOT NULL Foreign key to the USERS table. EMAIL1BAD SMALLINT NOT NULL This is a flag which indicates if the e-mail address in the EMAIL1 column of the ADDRESS table is considered invalid. The possible values are:
1 - invalid
0 - validEMAIL2BAD SMALLINT NOT NULL This is a flag which indicates if the e-mail address in the EMAIL2 column of the ADDRESS table is considered invalid. The possible values are:
1 - invalid
0 - validREASONCODE1 SMALLINT This column contains an SMTP code that corresponds to the reason why the EMAIL1 column of the ADDRESS table is considered invalid. REASONCODE2 SMALLINT This column contains an SMTP code that corresponds to the reason why the EMAIL2 column of the ADDRESS table is considered invalid. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030331230 USERS_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1038 USERS_ID USERS USERS_ID Cascade _vcc_freeselect_bottom_