WebSphere Commerce database table: USERREG

USERREG

This table stores user authentication information.

Column Descriptions:

Name 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 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 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.
IBMID VARCHAR (256) Reserved for IBM internal use.
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> USERS_ID Primary Key
I0000260 LOGONID Unique Index
I0000330 PLCYACCT_ID Non-Unique Index
I0001535 IBMID Non-Unique Index
I716117 LOGONID+USERS_ID Non-Unique Index

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_894 PLCYACCT_ID PLCYACCT PLCYACCT_ID Cascade
F_895 USERS_ID USERS USERS_ID Cascade

Referenced By Child Tables:

Constraint Columns Child Table Child Columns Type
F_3476 USERS_ID USERPWDHST USERS_ID Cascade

Related reference
Member data model
Authentication data model

Name	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 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 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.
IBMID	VARCHAR (256)	Reserved for IBM internal use.
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.

Name	Column Names	Type
<SYSTEM-GENERATED>	USERS_ID	Primary Key
I0000260	LOGONID	Unique Index
I0000330	PLCYACCT_ID	Non-Unique Index
I0001535	IBMID	Non-Unique Index
I716117	LOGONID+USERS_ID	Non-Unique Index

Constraint	Columns	Parent Table	Parent Columns	Type
F_894	PLCYACCT_ID	PLCYACCT	PLCYACCT_ID	Cascade
F_895	USERS_ID	USERS	USERS_ID	Cascade