Database Table: USERS

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

Column Name Column Type Column Description
DN VARCHAR (1000)
NULL
Reserved for IBM internal use.
FIELD1 VARCHAR (254)
NULL
Customizable.
FIELD2 VARCHAR (254)
NULL
Customizable.
FIELD3 VARCHAR (254)
NULL
Customizable.
LANGUAGE_ID INTEGER
NULL
Preferred language. For a list of language components, see the LANGUAGE table. Foreign key relationship to LANGUAGE table.
LASTORDER TIMESTAMP
NULL
The date and time that the user last placed an order at this site.
LASTSESSION TIMESTAMP
NULL
The date and time that the user last visited the WebSphere Commerce site. Last visited means last logon to the WebSphere Commerce site.
PREVLASTSESSION TIMESTAMP
NULL
Reserved for IBM internal use.
PROFILETYPE CHARACTER (2)
NULL
Identifies whether there is a profile and what type of profile this user has. Valid values are as follows:
Null - no profile data
C - base profile data
B - business profile data
REGISTERTYPE CHARACTER (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).
REGISTRATION TIMESTAMP
NULL
The date or time that the user was registered, directly by way of UserRegistrationAdd, during synchronization from LDAP to the WebSphere Commerce database.
REGISTRATIONCANCEL TIMESTAMP
NULL
Reserved for IBM internal use.
REGISTRATIONUPDATE TIMESTAMP
NULL
The date or time the user last changed registration information. This value is set during UserRegistrationAdd and UserRegistrationUpdate ResetPassword synchronization with LDAP during logon.
SETCCURR CHARACTER (3)
NULL
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 in the SHOPPER table.
USERS_ID BIGINT
NOT NULL
ID for the user member. Foreign key to MEMBER_ID in MEMBER table.
Indexes:
Index Name Indexed Column Names Index Type
I348118 PROFILETYPE, REGISTERTYPE, USERS_ID Non-Unique Index
SQL030416035142230 USERS_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint 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:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_134 USERS_ID BUSPROF USERS_ID Cascade
F_16 USERS_ID ACCLOGMAIN USERS_ID Cascade
F_17 USERS_ID ACCLOGSUB 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_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_899 USERS_ID USRTRAFFIC 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