WebSphere Commerce database table: EMLBADADDR

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:

Name 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 NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name Column Names Type
<SYSTEM-GENERATED> USERS_ID Primary Key

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_1038 USERS_ID USERS USERS_ID Cascade

Name	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.