USERS

This table contains all users of the WebSphere Commerce system: registered users, guest users, and generic users.

Column Descriptions:

NameTypeDescription
USERS_IDBIGINT NOT NULLID for the user member. Foreign key to MEMBER_ID in MEMBER table.
DNVARCHAR (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.
REGISTERTYPECHAR (4) NOT NULLThe 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.
PROFILETYPECHAR (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_IDINTEGERPreferred language. For a list of language components, see the LANGUAGE table. Foreign key relationship to LANGUAGE table.
FIELD1VARCHAR (254)Customizable.
SETCCURRCHAR (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.
FIELD3VARCHAR (254)Customizable.
FIELD2VARCHAR (254)Customizable.
LASTORDERTIMESTAMPThe date and time that the user last placed an order at this site.
REGISTRATIONTIMESTAMPThe date or time that the user was registered, directly by way of UserRegistrationAdd, during synchronization from LDAP to the HCL Commerce database.
LASTSESSIONTIMESTAMPThe date and time that the user last visited the HCL Commerce site. Last visited means last logon to the HCL Commerce site.
REGISTRATIONUPDATETIMESTAMPThe date or time the user last changed registration information. This value is set during UserRegistrationAdd and UserRegistrationUpdate ResetPassword synchronization with LDAP during logon.
REGISTRATIONCANCELTIMESTAMPReserved for HCL internal use.
PREVLASTSESSIONTIMESTAMPReserved for HCL internal use.
PERSONALIZATIONIDVARCHAR (30)The Personalization ID associated with the user
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>USERS_IDPrimary Key
I0000969DNNon-Unique Index
I0000971REGISTERTYPENon-Unique Index
I0001109PERSONALIZATIONIDNon-Unique Index
I348118PROFILETYPE+REGISTERTYPE+USERS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_896USERS_IDMEMBERMEMBER_IDCascade
F_897LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_898SETCCURRSETCURRSETCCURRCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1035USERS_IDEMLBOUNCEDUSERS_IDCascade
F_1038USERS_IDEMLBADADDRUSERS_IDCascade
F_1052USERS_IDPX_COUPONUSERS_IDCascade
F_1055USERS_IDPX_USAGEUSERS_IDCascade
F_1163USERS_IDCCOMMENTCREATEDBYCascade
F_1164USERS_IDCCOMMENTLASTUPDATEDBYCascade
F_134USERS_IDBUSPROFUSERS_IDCascade
F_21USERS_IDACCMBRGRPUSERS_IDCascade
F_232USERS_IDCERT_X509USERS_IDCascade
F_263USERS_IDCPOFFERUSERS_IDCascade
F_276USERS_IDCPWALLETUSERS_IDCascade
F_3609USERS_IDPX_CDUSAGEOWNER_IDCascade
F_61USERS_IDAPRVSTATUSSUBMITTER_IDCascade
F_62USERS_IDAPRVSTATUSAPPROVER_IDCascade
F_633USERS_IDPVCBINDINGUSERS_IDCascade
F_635USERS_IDPVCBUFFERUSERS_IDCascade
F_639USERS_IDPVCSESSIONREGISTER_IDCascade
F_888USERS_IDUSERDEMOUSERS_IDCascade
F_889USERS_IDUSERPROFUSERS_IDCascade
F_891USERS_IDUSERPVCDEVUSERS_IDCascade
F_895USERS_IDUSERREGUSERS_IDCascade
F_955USERS_IDQUEUECSRCSR_IDCascade
F_961USERS_IDEMLRPTEVTSUSERS_IDCascade
F_966USERS_IDEMLUSRRECVUSERS_IDCascade
R_3462USERS_IDORCOMMENTSERVICEREP_IDCascade