Database Table: USERPROF

This table contains basic registered user profile information.

Column Name Column Type Column Description
DESCRIPTION VARCHAR (4000)
NULL
Description of the user.
DISPLAYNAME VARCHAR (128)
NULL
Display name of the entry. This is a name used in displaying an entry in a one line summary list.
FIELD1 VARCHAR (254)
NULL
Customizable.
FIELD2 VARCHAR (254)
NULL
Customizable.
PHOTO VARCHAR (254)
NULL
A location for the photograph of the user.
PREFERREDCOMM CHARACTER (2)
NULL
Preferred method of communication by phone. Valid values are as follows:
P1 - primary phone number
P2 - secondary or alternate phone number
PREFERREDDELIVERY VARCHAR (1000)
NULL
Preferred delivery method.
PREFERREDMEASURE CHARACTER (15)
NULL
Reserved for IBM internal use.
TAXPAYERID VARCHAR (254)
NULL
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.
USERS_ID BIGINT
NOT NULL
Foreign key relationship to the USERS table for this registered user.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035141190 USERS_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_889 USERS_ID USERS USERS_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable