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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I348118 | PROFILETYPE, REGISTERTYPE, USERS_ID | Non-Unique Index |
SQL030416035142230 | USERS_ID | Primary Key |
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 |
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 |