PROFNVSTRG

This table holds additional attributes for the profiles in the form of name-value pairs. Can be utilized for user-attributes.

Column Descriptions:

NameTypeDescription
PROFNVSTRG_IDINTEGER NOT NULLUnique key for this table.
PROFILE_IDINTEGER NOT NULLForeign key to profile table. Represents the profile this record is applicable to.
PROFILEATTNAMEVARCHAR (254) NOT NULLName of the attribute.
PROFILEATTVALUEVARCHAR (254) NOT NULLValue for the attribute.
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>PROFNVSTRG_IDPrimary Key
I0000193PROFILE_ID+PROFILEATTNAMEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_627PROFILE_IDPROFILEPROFILE_IDCascade