USERPROF

This table contains basic registered user profile information.

Column Descriptions:

NameTypeDescription
USERS_IDBIGINT NOT NULLForeign key relationship to the USERS table for this registered user.
PHOTOVARCHAR (254)A location for the photograph of the user.
DESCRIPTIONVARCHAR (4000)Description of the user.
DISPLAYNAMEVARCHAR (128)Display name of the entry. This is a name used in displaying an entry in a one line summary list.
PREFERREDCOMMCHAR (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
PREFERREDDELIVERYVARCHAR (1000)Preferred delivery method.
PREFERREDMEASURECHAR (15)Preferred unit of measurement, for example, Metric or Imperial.
FIELD1VARCHAR (254)Customizable.
TAXPAYERIDVARCHAR (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.
FIELD2VARCHAR (254)Customizable.
RCVSMSNOTIFICATIONSMALLINT NOT NULL DEFAULT 0SMS text messaging preference. Indicates whether the user wants to receive order notification SMS text messages.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>USERS_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_889USERS_IDUSERSUSERS_IDCascade