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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000193 | PROFILE_ID, PROFILEATTNAME | Unique Index |
SQL030416035040900 | PROFNVSTRG_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_627 | PROFILE_ID | PROFILE | PROFILE_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|