USERPWDHST

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