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