This table contains all users of the WebSphere
Commerce system: registered users, guest users, and generic
users.
Column Descriptions:
| Name | Type | Description |
| USERS_ID | BIGINT NOT NULL | ID for the user member. Foreign key to MEMBER_ID
in MEMBER table. |
| DN | VARCHAR (1000) | The distinguished name of the user, for example,
uid=wcsadmin,o=root organization. It must be in lower case, and
should not have any spaces immediately before or after the , or =
symbols. When using LDAP, this value must correspond with the DN of
the user in the LDAP server. |
| REGISTERTYPE | CHAR (4) NOT NULL | The user registration type. Valid values are as
follows:
R - registered user
G - guest user
A - administrator
S - site administrator
The default member group called Administrators defines the
list of administrative roles.
|
| PROFILETYPE | CHAR (2) | Identifies whether the user has a profile, and if
so, the profile type. Valid values are as follows:
Null - no profile data
C - base profile data
B - business profile data |
| LANGUAGE_ID | INTEGER | Preferred language. For a list of language
components, see the LANGUAGE table. Foreign key relationship to
LANGUAGE table. |
| FIELD1 | VARCHAR (254) | Customizable. |
| SETCCURR | CHAR (3) | Preferred currency in 3-character alphabetic code
as per ISO 4217. This is a currency code as per ISO 4217 standards.
Compare with the
SHPREFERREDCURR column of the SHOPPER table provided
with previous versions of HCL Commerce or HCL Commerce
Suite. |
| FIELD3 | VARCHAR (254) | Customizable. |
| FIELD2 | VARCHAR (254) | Customizable. |
| LASTORDER | TIMESTAMP | The date and time that the user last placed an
order at this site. |
| REGISTRATION | TIMESTAMP | The date or time that the user was registered,
directly by way of UserRegistrationAdd, during synchronization from
LDAP to the HCL Commerce database. |
| LASTSESSION | TIMESTAMP | The date and time that the user last visited the
HCL Commerce site. Last visited means last logon to the
HCL Commerce site. |
| REGISTRATIONUPDATE | TIMESTAMP | The date or time the user last changed
registration information. This value is set during
UserRegistrationAdd and UserRegistrationUpdate ResetPassword
synchronization with LDAP during logon. |
| REGISTRATIONCANCEL | TIMESTAMP | Reserved for HCL internal use. |
| PREVLASTSESSION | TIMESTAMP | Reserved for HCL internal use. |
| PERSONALIZATIONID | VARCHAR (30) | The Personalization ID associated with the
user |
| 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 |
| I0000969 | DN | Non-Unique Index |
| I0000971 | REGISTERTYPE | Non-Unique Index |
| I0001109 | PERSONALIZATIONID | Non-Unique Index |
| I348118 | PROFILETYPE+REGISTERTYPE+USERS_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_896 | USERS_ID | MEMBER | MEMBER_ID | Cascade |
| F_897 | LANGUAGE_ID | LANGUAGE | LANGUAGE_ID | Cascade |
| F_898 | SETCCURR | SETCURR | SETCCURR | Cascade |
Referenced By Child Tables: