WebSphere Commerce database table: USERREG

This table stores user authentication information.


Column Description(s):
Column NameColumn TypeDescription
USERS_ID BIGINT NOT NULL ID for the user member. Foreign key to the USERS table.
STATUS INTEGER Allows 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_ID INTEGER The account policy for this user, foreign key to the PLCYACCT table.
LOGONID VARCHAR(254) NOT NULL The user logon ID.
LOGONPASSWORD BINARY The encrypted user logon password. Compare with the SHLPSWD column of the SHOPPER table provided with previous versions of WebSphere Commerce or WebSphere Commerce Suite.
PASSWORDEXPIRED INTEGER Specifies whether or not the user password has expired. Valid values are 0 (not expired) or 1 (expired).
CHALLENGEQUESTION VARCHAR(254) Challenge question for confirmation of the user identity. Compare with the SCHAQUE column of the SHOPPER table provided with previous versions of WebSphere Commerce or WebSphere Commerce Suite.
CHALLENGEANSWER VARCHAR(254) Answer to challenge question. Compare with the SHCHAANS column of the SHOPPER table provided with previous versions of WebSphere Commerce or WebSphere Commerce Suite.
TIMEOUT BIGINT NOT NULL DEFAULT -1 Time for which the user cannot log in after failed attempts to log in.
PASSWORDRETRIES INTEGER DEFAULT 0 The number of times consecutively the password is entered incorrectly.
SALT VARCHAR(254) The value that is prepended to the password before hashing.
PASSWORDCREATION TIMESTAMP The last time the password for the user was created or updated.
PASSWORDINVALID TIMESTAMP Timestamp of the last failed attempt to log in.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000260 LOGONID Unique Index
SQL050212031325160 USERS_ID Primary Key
I0000330 PLCYACCT_ID Non-Unique Index
I716117 LOGONID+USERS_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_894 PLCYACCT_ID PLCYACCT PLCYACCT_ID Cascade
F_895 USERS_ID USERS USERS_ID Cascade

Feedback