Reference > Database > WebSphere Commerce database tables > U
WebSphere Commerce database table: USERS
This table contains all users of the WebSphere Commerce system: registered users, guest users, and generic users.
Column Name Column 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...
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...
Null - no profile data
C - base profile data
B - business profile dataLANGUAGE_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. OPTCOUNTER SMALLINT Reserved for IBM internal use. PERSONALIZATIONID VARCHAR(30) The Personalization ID associated with the user
Indexes Index Name Indexed Column Names Index Type SQL100520030445050 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
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_897 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade F_896 USERS_ID MEMBER MEMBER_ID Cascade F_898 SETCCURR SETCURR SETCCURR Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_21 USERS_ID ACCMBRGRP USERS_ID Cascade F_61 SUBMITTER_ID APRVSTATUS USERS_ID Cascade F_62 APPROVER_ID APRVSTATUS USERS_ID Cascade F_134 USERS_ID BUSPROF USERS_ID Cascade F_1164 LASTUPDATEDBY CCOMMENT USERS_ID Cascade F_1163 CREATEDBY CCOMMENT 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_1038 USERS_ID EMLBADADDR USERS_ID Cascade F_1035 USERS_ID EMLBOUNCED USERS_ID Cascade F_961 USERS_ID EMLRPTEVTS USERS_ID Cascade F_966 USERS_ID EMLUSRRECV USERS_ID Cascade R_3462 SERVICEREP_ID ORCOMMENT USERS_ID Cascade F_633 USERS_ID PVCBINDING USERS_ID Cascade F_635 USERS_ID PVCBUFFER USERS_ID Cascade F_639 REGISTER_ID PVCSESSION USERS_ID Cascade F_3609 OWNER_ID PX_CDUSAGE USERS_ID Cascade F_1052 USERS_ID PX_COUPON USERS_ID Cascade F_1055 USERS_ID PX_USAGE USERS_ID Cascade F_955 CSR_ID QUEUECSR USERS_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
Related reference
- Customer care data model
- Authentication data model
- User traffic data model
- Member data model
- Mobile device data model
- E-coupon data model
- Access logging data model
_vcc_freeselect_bottom_