Subject Area : 060 - Role
Subject Area(s) of Model "Renoir Domain Model Detail"
# Name Definition ER Diagram Entity/Table
Total
. 060 - Role Shows the different types of FootPrints Roles and the relationship to Application User types and Use Profiles. There is some redundancy of function in the Perl FootPrints security model that is the subject of design here. Details.. Details..
ER Diagram(s) of Subject Area "060 - Role"
# Name Physical Display Level
Total 2
. Logical Column
. Physical Column
Entity/Table(s) of Subject Area "060 - Role"
# Physical Name Name Logical Only Do Not Generate Definition Attribute/Column
Total 25
. admin Administrator CMDB Role true true An Administrator CMDB Role. Details..
. admin_type Administrator Type false The administrator type indicates whether the instance is a system role or not. This is important, since certain preferences cannot be changed on the system administrator role. Values include SYSTEM, WORKSPACE, AGENT.

Details..
. agent_role Agent Role true true A role that identifies a user as an agent, and also provides more specific information about the application behavior for the agent. Details..
. app_role Application Role false 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. Details..
. cmdb_role CMDB Role true true A role in the CMBD container Details..
. cfg_setting_val Configuration Setting Value false Configuration Setting Value is an association between the Configuration Setting entity and a container entity (i.e. User Profile, Role, and Definition). This association contains a distinct value for each of the intersection points between the two entities. Details..
. create_edit Create Edit CMDB Role true true A Create Edit CMDB Role Details..
. custom Custom CMDB Role true true A custom CMBD role. Details..
. cust_read_knowledge_base_and_r Customer Read Knowledge Base and Requests Role true true A built in role that identifies a user as a customer, and also provides more specific information about the application behavior for the customer. Generally it specifically grants authorization for certain functions. Details..
. cust_read_knowledge_base_role Customer Read Knowledge Base Role true true A built in role that identifies a user as a customer, and also provides more specific information about the application behavior for the customer. Generally it specifically grants authorization for certain functions. Details..
. cust_read_submit_role Customer Read/Submit Role true true A built in role that identifies a user as a customer, and also provides more specific information about the application behavior for the customer. Generally it specifically grants authorization for certain functions. Details..
. cust_read_submit_edit_role Customer Read/Submit/Edit Role true true A built in role that identifies a user as a customer, and also provides more specific information about the application behavior for the customer. Generally it specifically grants authorization for certain functions. Details..
. cust_role Customer Role true true A role that identifies a user as a customer, and also provides more specific information about the application behavior for the customer. Details..
. defn Definition false A definition holds the structural and behavioral information needed for an application element that is configuarable by the system designer and/or the end user at definition time. Current Footrpints uses a combination of directories, files, tables, and programming code to represent this information. The new FootPrints will provide all of the same information within the definition. The definition can be persisted in a structure that is isolated at the Instance Level. The data for the definition will be stored as Configuration Settings associated with the Definition Version. See the database views v_defn_ver_active, v_cntnr_item_field. Details..
. defn_subtype Definition Subtype false The subtype of the definition used as a discriminator for the class of definition. Each subtype will have different configuration settings and associated definitions. These include associated built-in field definitions for item subtypes. See the database view v_defn_subtype. Details..
. read_only Read Only CMDB Role true true A Read Only CMDB Role. Details..
. role_grp Role Group false (Not used, but referenced in Java code that must be removed before table deletion.) The role group will contain the roles that the user has for each of the workspaces that the user has access. The user will always have a role group even if the administrator chooses the Perl Footprints functionality. Details..
. role_grp_role Role Group Role false (Not used, but referenced in Java code that must be removed before table deletion.) an association table that resolves the many to many relationship between the Role Group and the Role entities. Details..
. sys_admin_role System Administrator Role true true A built in role that identifies a user as a system administrator, and also provides more specific information about the application behavior for the agent. Details..
. tmpl_app_role Template Application Role true true The role template will function as a system preedefined role that can then be linked to workspace roles. Changes made to the system role will be refclected at the workspace level until the connection is broken. This system role's connection to the workspace role will be in effect until any change is made to the workspace role. It then gets copied over as a stand alone role. 12/8/2011 The Role Template will be implemented as a subtype of role. Details..
. user_defined_agent_role User Defined Agent Role true true A role that identifies a user as an agent in the FootPrints system, and also provides more specific information about the application behavior for the agent. This is configured by the user or is a copy of a pre-existing role. Details..
. user_defined_cust_role User Defined Customer Role true true A role that identifies a user as a customer in the FootPrints system, and also provides more specific information about the application behavior for the agent. This is configured by the user or is a copy of a pre-existing customer role. Details..
. user_prof User Profile false 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.
Details..
. user_type User Type false Indicates whether this entity is of an agent type or a customer type. Also CMDB and GUEST. Details..
. wksp_admin_role Workspace Administrator Role true true A built in role that identifies a user as a workspace administrator, and also provides more specific information about the application behavior for the agent. Details..
Attribute/Column(s) of Entity/Table "Administrator CMDB Role"
# Physical Name Name Definition Physical Data Type
Total 1
. app_role_id Application Role Id A Foreign Key to the Application Role table. bigint
Attribute/Column(s) of Entity/Table "Administrator Type"
# Physical Name Name Definition Physical Data Type
Total 2
. admin_type_name Administrator Type Name The name of the Administrator Type. varchar(255)
. admin_type_id Administrator Type Id The automatically generated primary key of the admin_type table. int
Attribute/Column(s) of Entity/Table "Agent Role"
# Physical Name Name Definition Physical Data Type
Total 2
. admin_type_id Administrator Type Id A Foreign Key to the Administrator Type table. int
. app_role_id Application Role Id A Foreign Key to the Application Role table. bigint
Attribute/Column(s) of Entity/Table "Application Role"
# Physical Name Name Definition Physical Data Type
Total 11
. app_role_id Application Role Id The automatically generated primary key of the app_role table. bigint
. tmpl_app_role_id Template Application Role Id 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. bigint
. app_role_name Application Role Name The name of the Application Role. varchar(255)
. defn_id Definition Id A Foreign Key to the Definition table. bigint
. admin_type_id Administrator Type Id A Foreign Key to the Administrator Type table. int
. is_built_in Is Built In Indicates that this instance of Application Role is a built-in instance that cannot be changed by the end user. bit
. app_role_descr Application Role Description A descriptive name of the Application Role. This descriptive name may be localized. varchar(1024)
. user_type_id User Type Id A Foreign Key to the User Type table. int
. defn_subtype_id Definition Subtype Id A Foreign Key to the Definition Subtype table. int
. tmpl_app_role_id Template Application Role Id A Foreign Key to the Application Role table. bigint
. tmpl_level_name tmpl_level_name The value of a Built_in_level, stored as a string. varchar(255)
Attribute/Column(s) of Entity/Table "CMDB Role"
# Physical Name Name Definition Physical Data Type
Total 1
. app_role_id Application Role Id A Foreign Key to the Application Role table. bigint
Attribute/Column(s) of Entity/Table "Configuration Setting Value"
# Physical Name Name Definition Physical Data Type
Total 13
. cfg_setting_val_id Configuration Setting Value Id The automatically generated primary key of the cfg_setting_val table. bigint
. cfg_setting_id Configuration Setting Id A Foreign Key to the Configuration Setting table. bigint
. val_type_cd Value Type Code The data type for a Configuration Setting Value. The choices are 'S' string, 'D' date, 'T' text, 'I' integer. char(1)
. string_val String Value The value of a Configuration Setting Value, stored as a string. nvarchar(4000)
. text_val Text Value The value of a Configuration Setting Value, stored as a long text object. nvarchar(max)
. real_val Real Value The value of a Configuration Setting Value stored as a real. numeric(38,20)
. long_val Long Value The value of a Configuration Setting Value stored as Long. bigint
. date_val Date Value The value of a Configuration Setting Value, stored as a date. datetime
. boolean_val Boolean Value The value of a Configuration Setting Value stored as Boolean. bit
. int_val Int Value The value of a Configuration Setting Value stored as Int. int
. owner_id Owner Id A Foreign Key to the Owning instance in either the Definition, Definition Version , Role, or User Profile tables. bigint
. val_map_key Value Map Key The value of a Configuration Setting Value, stored as a string. varchar(255)
. cfg_setting_owner_type_name Configuration Setting Owner Type Name The unique string identifier for an instance of Configuration Setting Owner Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. varchar(255)
Attribute/Column(s) of Entity/Table "Create Edit CMDB Role"
# Physical Name Name Definition Physical Data Type
Total 1
. app_role_id Application Role Id A Foreign Key to the Application Role table. bigint
Attribute/Column(s) of Entity/Table "Custom CMDB Role"
# Physical Name Name Definition Physical Data Type
Total 1
. app_role_id Application Role Id A Foreign Key to the Application Role table. bigint
Attribute/Column(s) of Entity/Table "Customer Read Knowledge Base and Requests Role"
# Physical Name Name Definition Physical Data Type
Total 1
. app_role_id Application Role Id A Foreign Key to the Application Role table. bigint
Attribute/Column(s) of Entity/Table "Customer Read Knowledge Base Role"
# Physical Name Name Definition Physical Data Type
Total 1
. app_role_id Application Role Id A Foreign Key to the Application Role table. bigint
Attribute/Column(s) of Entity/Table "Customer Read/Submit Role"
# Physical Name Name Definition Physical Data Type
Total 1
. app_role_id Application Role Id A Foreign Key to the Application Role table. bigint
Attribute/Column(s) of Entity/Table "Customer Read/Submit/Edit Role"
# Physical Name Name Definition Physical Data Type
Total 1
. app_role_id Application Role Id A Foreign Key to the Application Role table. bigint
Attribute/Column(s) of Entity/Table "Customer Role"
# Physical Name Name Definition Physical Data Type
Total 1
. app_role_id Application Role Id A Foreign Key to the Application Role table. bigint
Attribute/Column(s) of Entity/Table "Definition"
# Physical Name Name Definition Physical Data Type
Total 7
. defn_id Definition Id The automatically generated primary key of the defn table. bigint
. defn_name Definition Name The name of the Definition. nvarchar(4000)
. dsble_date Disabled Date The date that this instance of Definition is logically deleted and disabled. datetime
. defn_guid Definition GUID A Global Unique IDentifier search key for the Definition, composed of letters and numbers. It is computed by the client and typically used in unstructured data. varchar(50)
. defn_type_name Definition Type Name The unique string identifier for an instance of Definition Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. varchar(255)
. defn_subtype_id Definition Subtype Id A Foreign Key to the Definition Subtype table. int
. tmpl_export_guid Template Export GUID The value of a Definition, stored as a string. VARCHAR(50)
Attribute/Column(s) of Entity/Table "Definition Subtype"
# Physical Name Name Definition Physical Data Type
Total 6
. defn_subtype_name Definition Subtype Name The name of the Definition Subtype. varchar(255)
. defn_subtype_descr Definition Subtype Description A descriptive name of the Definition Subtype. This descriptive name may be localized. varchar(512)
. defn_subtype_id Definition Subtype Id The automatically generated primary key of the defn_subtype table. int
. defn_parent_subtype_id definition parent subtype id A Foreign Key to the Definition Subtype table. int
. defn_type_name Definition Type Name The unique string identifier for an instance of Definition Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. varchar(255)
. max_in_parent Maximum In Parent A Foreign Key to the Definition Subtype table. int
Attribute/Column(s) of Entity/Table "Read Only CMDB Role"
# Physical Name Name Definition Physical Data Type
Total 1
. app_role_id Application Role Id A Foreign Key to the Application Role table. bigint
Attribute/Column(s) of Entity/Table "Role Group"
# Physical Name Name Definition Physical Data Type
Total 3
. role_grp_id Role Group Id The automatically generated primary key of the role_grp table. bigint
. role_grp_name Role Group Name The name of the Role Group. varchar(255)
. role_grp_descr Role Group Description A descriptive name of the Role Group. This descriptive name may be localized. varchar(512)
Attribute/Column(s) of Entity/Table "Role Group Role"
# Physical Name Name Definition Physical Data Type
Total 3
. app_role_id Application Role Id A Foreign Key to the Application Role table. bigint
. role_grp_role_id Role Group Role Id The automatically generated primary key of the role_grp_role table. bigint
. role_grp_id Role Group Id A Foreign Key to the Role Group table. bigint
Attribute/Column(s) of Entity/Table "System Administrator Role"
# Physical Name Name Definition Physical Data Type
Total 1
. app_role_id Application Role Id A Foreign Key to the Application Role table. bigint
Attribute/Column(s) of Entity/Table "Template Application Role"
# Physical Name Name Definition Physical Data Type
Total 1
. app_role_id Application Role Id A Foreign Key to the Application Role table. bigint
Attribute/Column(s) of Entity/Table "User Defined Agent Role"
# Physical Name Name Definition Physical Data Type
Total 1
. app_role_id Application Role Id A Foreign Key to the Application Role table. bigint
Attribute/Column(s) of Entity/Table "User Defined Customer Role"
# Physical Name Name Definition Physical Data Type
Total 1
. app_role_id Application Role Id A Foreign Key to the Application Role table. bigint
Attribute/Column(s) of Entity/Table "User Profile"
# Physical Name Name Definition Physical Data Type
Total 15
. user_prof_id User Profile Id The automatically generated primary key of the user_prof table. bigint
. tmpl_user_prof_id Template User Profile Id 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. bigint
. role_grp_id Role Group Id 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. bigint
. defn_id Definition Id A Foreign Key to the Definition table. Optionally, the container that owns the profile. bigint
. app_role_id Application Role Id 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. bigint
. agent_authcn_type_id Agent Authentication Type Id A Foreign Key to the Agent Authentication Type table. int
. user_prof_name User Profile Name The name of the User Profile. varchar(255)
. is_built_in Is Built In Indicates that this instance of User Profile is a built-in instance that cannot be changed by the end user. bit
. user_type_id User Type Id A Foreign Key to the User Type table. int
. cust_authcn_type_id Customer Authentication Type Id A Foreign Key to the Customer Authentication Type table. int
. is_sys Is System Indicates if this is a system level profile. bit
. defn_subtype_id Definition Subtype Id A Foreign Key to the Definition Subtype table. int
. delete_date Delete Date The value of a User Profile, stored as a date. datetime
. last_login Last Login date time of last login in UTC. datetime
. tmpl_level_name tmpl_level_name The value of a Built_in_level, stored as a string. varchar(255)
Attribute/Column(s) of Entity/Table "User Type"
# Physical Name Name Definition Physical Data Type
Total 3
. user_type_name User Type Name The name of the User Type. varchar(255)
. user_type_id User Type Id The automatically generated primary key of the user_type table. int
. user_type_descr User Type Description A descriptive name of the User Type. This descriptive name may be localized. varchar(512)
Attribute/Column(s) of Entity/Table "Workspace Administrator Role"
# Physical Name Name Definition Physical Data Type
Total 1
. app_role_id Application Role Id A Foreign Key to the Application Role table. bigint