Footprints Data Model

Table
Name user_prof
Comment
A container for Permissions and Settings (the composite parts are the
associated Role and the User Preferences). The permissions for a User to access
a particular container according to the capabilities defined.  In most cases
this will be more defined in a subcategory.

Example: Shared User Profile
This profile will be shared between multiple users that access the system with
the same User ID.

Column
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