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 | 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 |