WebSphere Commerce database table: USERPROF

USERPROF

This table contains basic registered user profile information.

Column Descriptions:

Name Type Description
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, for example:

P1 - first phone number

P2 - second or alternate phone number

E1 - first email address

E2 - second email address

F1 - first fax number

F2 - second fax number

PREFERREDDELIVERY VARCHAR (1000) Preferred delivery method.
PREFERREDMEASURE CHAR (15) Preferred unit of measurement, for example, Metric or Imperial.
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.
RCVSMSNOTIFICATION SMALLINT NOT NULL DEFAULT 0 SMS text messaging preference. Indicates whether the user wants to receive order notification SMS text messages.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name Column Names Type
<SYSTEM-GENERATED> USERS_ID Primary Key

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_889 USERS_ID USERS USERS_ID Cascade

Related reference
Member data model

Name	Type	Description
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, for example: P1 - first phone number P2 - second or alternate phone number E1 - first email address E2 - second email address F1 - first fax number F2 - second fax number
PREFERREDDELIVERY	VARCHAR (1000)	Preferred delivery method.
PREFERREDMEASURE	CHAR (15)	Preferred unit of measurement, for example, Metric or Imperial.
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.
RCVSMSNOTIFICATION	SMALLINT NOT NULL DEFAULT 0	SMS text messaging preference. Indicates whether the user wants to receive order notification SMS text messages.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.