Database Table: USERREG

This table stores user authentication information.

Column Name Column Type Column Description
CHALLENGEANSWER VARCHAR (254)
NULL
Answer to challenge question. Compare with the SHCHAANS column of the SHOPPER table provided with previous versions of WebSphere Commerce or WebSphere Commerce Suite.
CHALLENGEQUESTION VARCHAR (254)
NULL
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.
LOGONID VARCHAR (254)
NOT NULL
The user logon ID.
LOGONPASSWORD CHARACTER (128)
NULL
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.
PASSWORDCREATION TIMESTAMP
NULL
The last time the password for the user was created or updated.
PASSWORDEXPIRED INTEGER
NULL
Specifies whether or not the user password has expired. Valid values are 0 (not expired) or 1 (expired).
PASSWORDINVALID TIMESTAMP
NULL
Timestamp of the last failed attempt to log in.
PASSWORDRETRIES INTEGER
NULL, DEFAULT 0
The number of times consecutively the password is entered incorrectly.
PLCYACCT_ID INTEGER
NULL
The account policy for this user, foreign key to the PLCYACCT table.
SALT VARCHAR (254)
NULL
The value that is prepended to the password before hashing.
STATUS INTEGER
NULL
Allows the user to have the logon ID disabled without removing the user from the system. Valid values are 1 (enabled) or 0 (disabled).
TIMEOUT BIGINT
NOT NULL, DEFAULT -1
Time for which the user cannot log in after failed attempts to log in.
USERS_ID BIGINT
NOT NULL
ID for the user member. Foreign key to the USERS table.
Indexes:
Index Name Indexed Column Names Index Type
I0000260 LOGONID Unique Index
I0000330 PLCYACCT_ID Non-Unique Index
I716117 LOGONID, USERS_ID Non-Unique Index
SQL030416035141880 USERS_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_894 PLCYACCT_ID PLCYACCT PLCYACCT_ID Cascade
F_895 USERS_ID USERS USERS_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable