Database Table: PROFNVSTRG

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

Column Name Column Type Column Description
PROFILEATTNAME VARCHAR (254)
NOT NULL
Name of the attribute.
PROFILEATTVALUE VARCHAR (254)
NOT NULL
Value for the attribute.
PROFILE_ID INTEGER
NOT NULL
Foreign key to profile table. Represents the profile this record is applicable to.
PROFNVSTRG_ID INTEGER
NOT NULL
Unique key for this table.
Indexes:
Index Name Indexed Column Names Index Type
I0000193 PROFILE_ID, PROFILEATTNAME Unique Index
SQL030416035040900 PROFNVSTRG_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_627 PROFILE_ID PROFILE PROFILE_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable