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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035141190 | USERS_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_889 | USERS_ID | USERS | USERS_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|