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) | 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 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 |
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 in the SHOPPER table. |
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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031325290 | USERS_ID | Primary Key |
I0000969 | DN | Non-Unique Index |
I0000971 | REGISTERTYPE | Non-Unique Index |
I348118 | PROFILETYPE+REGISTERTYPE+USERS_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | 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 Name(s) | 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 |
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 |