Reference > Database > WebSphere Commerce database tables > U


WebSphere Commerce database table: USERREG

This table stores user authentication information.

Column Name Column Type Description
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...

  • 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 appended 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.

Indexes
Index Name Indexed Column Names Index Type
I0000260 LOGONID Unique Index
SQL100520030444920 USERS_ID Primary Key
I0000330 PLCYACCT_ID Non-Unique Index
I716117 LOGONID+USERS_ID Non-Unique Index

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
F_3476 USERS_ID USERPWDHST USERS_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search