USERREG

This table stores user authentication information.

Column Descriptions:

NameTypeDescription
USERS_IDBIGINT NOT NULLID for the user member. Foreign key to the USERS table.
STATUSINTEGERAllows the user to have the logon ID disabled without removing the user from the system. Valid values are as follows:
  • 1=enabled
  • 0=disabled
PLCYACCT_IDINTEGERThe account policy for this user, foreign key to the PLCYACCT table.
LOGONIDVARCHAR (254) NOT NULLThe user logon ID.
LOGONPASSWORDBINARYThe encrypted user logon password. Compare with the SHLPSWD column of the SHOPPER table provided with previous versions of HCL Commerce or HCL Commerce Suite.
PASSWORDEXPIREDINTEGERSpecifies whether or not the user password has expired. Valid values are 0 (not expired) or 1 (expired).
CHALLENGEQUESTIONVARCHAR (254)Challenge question for confirmation of the user identity. Compare with the SCHAQUE column of the SHOPPER table provided with previous versions of HCL Commerce or HCL Commerce Suite.
CHALLENGEANSWERVARCHAR (254)Answer to challenge question. Compare with the SHCHAANS column of the SHOPPER table provided with previous versions of HCL Commerce or HCL Commerce Suite.
TIMEOUTBIGINT NOT NULL DEFAULT -1Time for which the user cannot log in after failed attempts to log in.
PASSWORDRETRIESINTEGER DEFAULT 0The number of times consecutively the password is entered incorrectly.
SALTVARCHAR (254)The value that is appended to the password before hashing.
PASSWORDCREATIONTIMESTAMPThe last time the password for the user was created or updated.
PASSWORDINVALIDTIMESTAMPTimestamp of the last failed attempt to log in.
IBMIDVARCHAR (256)Reserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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
I0000260LOGONIDUnique Index
I0000330PLCYACCT_IDNon-Unique Index
I0001535IBMIDNon-Unique Index
I716117LOGONID+USERS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_894PLCYACCT_IDPLCYACCTPLCYACCT_IDCascade
F_895USERS_IDUSERSUSERS_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3476USERS_IDUSERPWDHSTUSERS_IDCascade