WebSphere Commerce database table: USERS

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

Column Descriptions
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) Reserved for IBM internal use.
REGISTERTYPE CHAR(4) NOT NULL The user registration type. Valid values are as follows:
R - registered user
G - guest user
The default member group called Administrators defines the list of administrative roles.
The following values are deprecated: S (Site Administrator) or A (administrative role as defined by the Administrators memberGroup).
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.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235305500 USERS_ID Primary Key
I0000969 DN Non-Unique Index
I0000971 REGISTERTYPE 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

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