WebSphere Commerce database table: USERPROF

This table contains basic registered user profile information.


Column Description(s):
Column NameColumn TypeDescription
USERS_ID BIGINT NOT NULL Foreign key relationship to the USERS table for this registered user.
PHOTO VARCHAR(254) A location for the photograph of the user.
DESCRIPTION VARCHAR(4000) Description of the user.
DISPLAYNAME VARCHAR(128) Display name of the entry. This is a name used in displaying an entry in a one line summary list.
PREFERREDCOMM CHAR(2) Preferred method of communication by phone. Valid values are as follows:
P1 - primary phone number
P2 - secondary or alternate phone number
PREFERREDDELIVERY VARCHAR(1000) Preferred delivery method.
PREFERREDMEASURE CHAR(15) Reserved for IBM internal use.
FIELD1 VARCHAR(254) Customizable.
TAXPAYERID VARCHAR(254) A string used to identify the user for taxation purpose. Addition of this column triggered by Taxware integration, but presumably this column is useful even outside of Taxware.
FIELD2 VARCHAR(254) Customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031324890 USERS_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_889 USERS_ID USERS USERS_ID Cascade

Feedback