Footprints Data Model

Table
Name app_role
Comment
A User Security Role within Footprints.  This includes Agent Users and Customer
Users, and includes Role settings at the Instance and Container level. 
Workspace Role and CMDB Role may both be implemented as Container Role.  The
Role has associated Rights and Permissions, and is a way of granting Roles and
Permissions to a User.  There is some conceptual overlap between the User
Profile and the Role.  The User is assigned a single Role as part of the User
Profile, and a User can only have one System Role and one Workspace Role.  The
User Profile can have property settings that override the Role Settings.

Column
Name Datatype Comment Is PK Is FK
app_role_id bigint The automatically generated primary key of the app_role table. Yes No
app_role_name varchar(255) The name of the Application Role. No No
app_role_descr varchar(1024)
A descriptive name of the Application Role.  This descriptive name may be
localized.
No No
defn_id bigint A Foreign Key to the Definition table. No Yes
admin_type_id int A Foreign Key to the Administrator Type table. No Yes
tmpl_app_role_id bigint
A Foreign Key to the Application Role table. This indicates which Template Role
was used to create a built-in role in case some features concerning new
properties added to later release of the system will need to be added to
existing templates.
No Yes
is_built_in bit
Indicates that this instance of Application Role is a built-in instance that
cannot be changed by the end user.
No No
user_type_id int A Foreign Key to the User Type table. No Yes
defn_subtype_id int A Foreign Key to the Definition Subtype table. No Yes