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. |
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 |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|