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