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