WebSphere Commerce database table: EMLBADADDR

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 Descriptions
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 - valid
EMAIL2BAD 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 - valid
REASONCODE1 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
SQL060903235154090 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

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 - valid
EMAIL2BAD	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 - valid
REASONCODE1	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.