Footprints Data Model

Table
Table Name Application Role
Table Definition 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.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Application Role Id The automatically generated primary key of the app_role table. LONG Yes
Application Role Name The name of the Application Role. VARCHAR(255) No
Application Role Description A descriptive name of the Application Role. This descriptive name may be localized. VARCHAR(1024) No
Definition Id A Foreign Key to the Definition table. LONG Yes
Is Built In Indicates that this instance of Application Role is a built-in instance that cannot be changed by the end user. BOOLEAN Yes
Template Application Role Id A Foreign Key to the Application Role table. LONG No
User Type Id A Foreign Key to the User Type table. INTEGER Yes
Definition Subtype Id A Foreign Key to the Definition Subtype table. INTEGER No
tmpl_level_name The value of a Built_in_level, stored as a string. VARCHAR(255) No
Administrator Type Id A Foreign Key to the Administrator Type table. INTEGER No