Name |
Datatype |
Comment |
Is PK |
Is FK |
user_prof_id |
bigint |
The automatically generated primary key of the user_prof table. |
Yes |
No |
role_grp_id |
bigint |
A Foreign Key to the Role Group table. A system level user profile can have a
role group, which will have the effect of assigning a collection of workspace,
cmdb, and address book roles at the container role level.
|
No |
Yes |
defn_id |
bigint |
A Foreign Key to the Definition table. Optionally, the container that owns the
profile.
|
No |
Yes |
app_role_id |
bigint |
A Foreign Key to the Application Role table. The User Profile is the means for
setting the default role at the system and workspace levels, and is also the
role of a Unique User Profile tied to a application user.
|
No |
Yes |
agent_authcn_type_id |
int |
A Foreign Key to the Agent Authentication Type table. |
No |
Yes |
user_prof_name |
varchar(255) |
The name of the User Profile. |
No |
No |
is_built_in |
bit |
Indicates that this instance of User Profile is a built-in instance that cannot
be changed by the end user.
|
No |
No |
tmpl_user_prof_id |
bigint |
A Foreign Key to the User Profile table. This will not be a navigable key in
the object model. This indicates which Template User Profile was used to create
a built-in template in case some features concerning new properties added to
later release of the system will need to be added to existing templates.
|
No |
Yes |
user_type_id |
int |
A Foreign Key to the User Type table. |
No |
Yes |
cust_authcn_type_id |
int |
A Foreign Key to the Customer Authentication Type table. |
No |
Yes |
is_sys |
bit |
Indicates if this is a system level profile. |
No |
No |
defn_subtype_id |
int |
A Foreign Key to the Definition Subtype table. |
No |
Yes |
delete_date |
datetime |
The value of a User Profile, stored as a date. |
No |
No |
last_login |
datetime |
date time of last login in UTC. |
No |
No |