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:
|
| 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 | 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 |