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 - 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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031224020 | USERS_ID | Primary Key |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_1038 | USERS_ID | USERS | USERS_ID | Cascade |