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:

NameTypeDescription
USERS_IDBIGINT NOT NULLForeign key to the USERS table.
EMAIL1BADSMALLINT NOT NULLThis 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
EMAIL2BADSMALLINT NOT NULLThis 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
REASONCODE1SMALLINTThis column contains an SMTP code that corresponds to the reason why the EMAIL1 column of the ADDRESS table is considered invalid.
REASONCODE2SMALLINTThis column contains an SMTP code that corresponds to the reason why the EMAIL2 column of the ADDRESS table is considered invalid.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>USERS_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1038USERS_IDUSERSUSERS_IDCascade