WebSphere Commerce database table: USERS

USERS

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 WebSphere Commerce or WebSphere 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 WebSphere Commerce database.
LASTSESSION TIMESTAMP The date and time that the user last visited the WebSphere Commerce site. Last visited means last logon to the WebSphere 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 IBM internal use.
PREVLASTSESSION TIMESTAMP Reserved for IBM 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:

Constraint Columns Child Table Child Columns Type
F_1035 USERS_ID EMLBOUNCED USERS_ID Cascade
F_1038 USERS_ID EMLBADADDR USERS_ID Cascade
F_1052 USERS_ID PX_COUPON USERS_ID Cascade
F_1055 USERS_ID PX_USAGE USERS_ID Cascade
F_1163 USERS_ID CCOMMENT CREATEDBY Cascade
F_1164 USERS_ID CCOMMENT LASTUPDATEDBY Cascade
F_134 USERS_ID BUSPROF USERS_ID Cascade
F_21 USERS_ID ACCMBRGRP USERS_ID Cascade
F_232 USERS_ID CERT_X509 USERS_ID Cascade
F_263 USERS_ID CPOFFER USERS_ID Cascade
F_276 USERS_ID CPWALLET USERS_ID Cascade
F_3609 USERS_ID PX_CDUSAGE OWNER_ID Cascade
F_61 USERS_ID APRVSTATUS SUBMITTER_ID Cascade
F_62 USERS_ID APRVSTATUS APPROVER_ID Cascade
F_633 USERS_ID PVCBINDING USERS_ID Cascade
F_635 USERS_ID PVCBUFFER USERS_ID Cascade
F_639 USERS_ID PVCSESSION REGISTER_ID Cascade
F_888 USERS_ID USERDEMO USERS_ID Cascade
F_889 USERS_ID USERPROF USERS_ID Cascade
F_891 USERS_ID USERPVCDEV USERS_ID Cascade
F_895 USERS_ID USERREG USERS_ID Cascade
F_955 USERS_ID QUEUECSR CSR_ID Cascade
F_961 USERS_ID EMLRPTEVTS USERS_ID Cascade
F_966 USERS_ID EMLUSRRECV USERS_ID Cascade
R_3462 USERS_ID ORCOMMENT SERVICEREP_ID Cascade

Related reference
Access logging data model
Member data model
Mobile device data model
Authentication data model
User traffic data model

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 WebSphere Commerce or WebSphere 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 WebSphere Commerce database.
LASTSESSION	TIMESTAMP	The date and time that the user last visited the WebSphere Commerce site. Last visited means last logon to the WebSphere 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 IBM internal use.
PREVLASTSESSION	TIMESTAMP	Reserved for IBM 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.

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

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

Constraint	Columns	Child Table	Child Columns	Type
F_1035	USERS_ID	EMLBOUNCED	USERS_ID	Cascade
F_1038	USERS_ID	EMLBADADDR	USERS_ID	Cascade
F_1052	USERS_ID	PX_COUPON	USERS_ID	Cascade
F_1055	USERS_ID	PX_USAGE	USERS_ID	Cascade
F_1163	USERS_ID	CCOMMENT	CREATEDBY	Cascade
F_1164	USERS_ID	CCOMMENT	LASTUPDATEDBY	Cascade
F_134	USERS_ID	BUSPROF	USERS_ID	Cascade
F_21	USERS_ID	ACCMBRGRP	USERS_ID	Cascade
F_232	USERS_ID	CERT_X509	USERS_ID	Cascade
F_263	USERS_ID	CPOFFER	USERS_ID	Cascade
F_276	USERS_ID	CPWALLET	USERS_ID	Cascade
F_3609	USERS_ID	PX_CDUSAGE	OWNER_ID	Cascade
F_61	USERS_ID	APRVSTATUS	SUBMITTER_ID	Cascade
F_62	USERS_ID	APRVSTATUS	APPROVER_ID	Cascade
F_633	USERS_ID	PVCBINDING	USERS_ID	Cascade
F_635	USERS_ID	PVCBUFFER	USERS_ID	Cascade
F_639	USERS_ID	PVCSESSION	REGISTER_ID	Cascade
F_888	USERS_ID	USERDEMO	USERS_ID	Cascade
F_889	USERS_ID	USERPROF	USERS_ID	Cascade
F_891	USERS_ID	USERPVCDEV	USERS_ID	Cascade
F_895	USERS_ID	USERREG	USERS_ID	Cascade
F_955	USERS_ID	QUEUECSR	CSR_ID	Cascade
F_961	USERS_ID	EMLRPTEVTS	USERS_ID	Cascade
F_966	USERS_ID	EMLUSRRECV	USERS_ID	Cascade
R_3462	USERS_ID	ORCOMMENT	SERVICEREP_ID	Cascade