This table stores the previously used passwords of
a registered user when the password policy of the user does not
allow the reuse the previous two passwords or more. Each row of the
table represents a password that has previously been used by the
user. When a user changes their password, the change password
process checks that the new password does not match any values for
that user.
Column Descriptions:
| Name | Type | Description |
| USERPWDHST_ID | BIGINT NOT NULL | A unique primary key for this table. |
| USERS_ID | BIGINT NOT NULL | ID for the registered user. Foreign key to the
USERREG table. |
| PREVLOGONPASSWORD | BINARY NOT NULL | The encrypted user logon password that has been
previously used. |
| SALT | VARCHAR (254) | The value that is appended to the password before
hashing. |
| PASSWORDCREATION | TIMESTAMP NOT NULL | The time that the password was created. |
| 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> | USERPWDHST_ID | Primary Key |
| I0001105 | USERS_ID+PASSWORDCREATION | Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3476 | USERS_ID | USERREG | USERS_ID | Cascade |