This table contains basic registered user profile information.
Column Name | Column 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 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 Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031324890 | USERS_ID | Primary Key |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_889 | USERS_ID | USERS | USERS_ID | Cascade |