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 | 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 |