Subject Area : 001 - High Level Domain Model
Subject Area Name Definition
001 - High Level Domain Model A high level Domain model indicating the logical concepts used to design both the Data Model and the persistent Object Model. This diagram has all of the main concepts needed to describe FootPrints 12. It was prepared by aggregating and summarizing 50 Logical Data Models prepared from analysis of some 700+ FootPrints 11 screen shots and associated functional descriptions of the new system. It is refined into physical tables in this model.
ER Diagram Name Physical Display Level
Entity Level Column
Table Level Table
Physical Name Entity/Table Name Logical Only Do Not Generate Definition
actvy_defn Activity Definition true true The definition of a task that must take place in order to fulfill an operation contract.

Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id A Foreign Key to the Definition table. bigint
addr_book Address Book Container true true A list of contacts that can be used to define customers. An address book can be used to define customers in a single workspace, and it can be shared among other workspaces. The fields of the Address Book can be customized. Data for the address book can be imported or exported.
 
This address book can be associated with multiple workspaces. These relationships willl be shown inside the definition relationship tables.

Physical Name Attribute/Column Name Definition Physical Data Type
enable_master_cntc_record Enable Master Contact Record Indicates if Enable Master Contact Record. bit
addr_book_cntnr_name Address Book Container Name The name of the Address Book Container. varchar(255)
prmry_key Primary Key A Foreign Key to the Address Field table. bigint
orgal_field Organizational Field A Foreign Key to the Address Field table. bigint
cntnr_type_id Container Type Id A Foreign Key to the Container Type table. int
addr_book_type_id Address Book Type Id A Foreign Key to the Address Book Type table. int
cntnr_id Container Id A Foreign Key to the Container table. bigint
agent Agent true true a user authorized to use the FootPrints agent functions, which enable the agent to provide services to the customer. These include the ability to edit, escalate, and close tickets.
Physical Name Attribute/Column Name Definition Physical Data Type
lic_type_id License Type Id A Foreign Key to the License Type table. bigint
app_user_id Application User Id A Foreign Key to the Application User table. bigint
app_ele Application Element false The identity and name of an element in the application implementation. An element can be one of many types, and can contain other elements. Example Application Elements include: a screen, a form, a dialog box, a text box, the Home Page, an Architecture Component, the Item Status field, the system values of the Item Status field. The Application Element is not the full implementation of the element, but is a key and nametag for the element. In many cases, a well-known algorithm can be used to locate the correct Application Element from the Application Element implementation. In other cases, an association to the Application Element Id must be recorded as part of the implementation.
Physical Name Attribute/Column Name Definition Physical Data Type
app_ele_id Application Element Id The automatically generated primary key of the app_ele table. bigint
app_ele_name Application Element Name The name of the Application Element. VARCHAR(2000)
intrnl_id Internal Id An alternate automatically generated key of the app_ele table. int
is_intrnl_flag Is Internal Flag A boolean flag for indicating if the Application Element is defined internally by Engineering or by Partners or is defined by the customer. bit
app_ele_type_id Application Element Type Id A Foreign Key to the Application Element Type table. int
intrnl_id_type_id Internal Identifier Type Id A Foreign Key to the Internal Identifier Type table. int
app_ele_nmsp_id Application Element Namespace Id A Foreign Key to the Application Element Namespace table. bigint
app_ele_string Application Element String false A string resource that is needed in English and other translations. The string is associated with an Application Element and a Usage, for example the Label , the Tooltip, etc.
Physical Name Attribute/Column Name Definition Physical Data Type
app_ele_string_id Application Element String Id The automatically generated primary key of the app_ele_string table. bigint
app_ele_id Application Element Id A Foreign Key to the Application Element table. bigint
string_usage_type_id String Usage Type Id A Foreign Key to the String Usage Type table. int
part_of_speech_id Part Of Speech Id The unique identifier for an instance of Part Of Speech. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. int
needs_mlple_plural_forms_flag Needs Multiple Plural Forms Flag A boolean flag that indicates that one string per plural form must be specified. An example is "{N} Records Found. numeric(1)
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.
Physical Name Attribute/Column Name Definition Physical Data Type
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)
app_user Application User false A user authorized to use the FootPrints system. The user is either a Customer User or an Agent User. The application user holds the minimum information needed to identify the user and associate the user with a user profile, where user settings are stored. A contact is not necessarily an application user. An application user entry is required in order for the user to access any online functions.
Physical Name Attribute/Column Name Definition Physical Data Type
pwd Password This space intentionally left blank. varchar(255)
user_name User Name The name of the Application User. nvarchar(4000)
cust_login_type_id Customer Login Type Id A Foreign Key to the Customer Login Type table. int
app_user_id Application User Id The automatically generated primary key of the app_user table. bigint
lic_type_id License Type Id A Foreign Key to the License Type table. bigint
user_login User Login The login name used to access the Application. This may not be filled in if external application security is used. nvarchar(4000)
email_addr Email Address An email address for the Application User. nvarchar(4000)
delete_date Delete Date The value of a Application User, stored as a date. datetime
appt Appointment true true A calendar appointment at a specific time for specific parties. This is logical, the actual appointment is stored in the Calendering tables that support iCal interchange.
asset_item Asset Item true true
Physical Name Attribute/Column Name Definition Physical Data Type
item_id Item Id A Foreign Key to the Item table. bigint
attch Attachment true true A binary or text file attachment that can be related to various entities that accept attachments, such as Issue or Emails.
attch_inbd_email Attachment Inbound Email false
attch_outbd_email Attachment Outbound Email false
audit_trail Audit Trail true true A listing of all changes made to information stored in the FootPrints system. This includes but is not necessarily limited to database column changes. All tables potentially have changes to them recorded here, so those relationships via a generic foreign key are not shown.
Physical Name Attribute/Column Name Definition Physical Data Type
item_id Item Id A Foreign Key to the Item table. bigint
audit_txn Audit Transaction true true A change made to information stored in the FootPrints system. This includes but is not necessarily limited to database column changes. All table potentially have changes to them recorded
audit_txn_audit_trail Audit Transaction Audit Trail false
Physical Name Attribute/Column Name Definition Physical Data Type
item_id Item Id A Foreign Key to the Item table. bigint
bus_rule_defn Business Rule Definition true true A Business rule is a statement that defines or constrains some aspect of the business. It is intended to assert business structure or to control or influence the behavior of the business.
Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id A Foreign Key to the Definition table. bigint
cmdb_cntnr CMDB Container true true A Configuration Management Database (CMDB) class of container. The CMDB container implements ITIL CMDB special features beyond the capabilities of the generic Container. The CMDB acts as a repository of Configuration Items and supports population, synchronization, and refererencing of items within it.
Physical Name Attribute/Column Name Definition Physical Data Type
cntnr_type_id Container Type Id A Foreign Key to the Container Type table. int
cntnr_id Container Id A Foreign Key to the Container table. bigint
cfg_item Configuration Item true true A specialization of Item contained in a CMDB container. A Configuration Item (CI) in the Configuration Management Data Base (CMDB). A Configuration Item is a repository item representing a software, hardware, or service item. There are important relationships to other items both within the CMDB but also externally to the CMDB. The CI has the ability to store fields as defined based on its CI Type. Current Footprints creates a table for the CI type named with the CMDB sequence identifier and the CI Type sequence identifier.
Physical Name Attribute/Column Name Definition Physical Data Type
item_id Item Id A Foreign Key to the Item table. bigint
cfg_setting Configuration Setting false A configuration variable that can be identified in programming code and which has an atomic value that affects the behavior of the application. Configuration values are either scalars, or are supported by value lists that also can be programmatically identified. They have localized labels and value choices, and are categorized to support organization and separation in programming namespaces and configuration screens. They support the concept of Built-In Values, Default Values, and Customized Values. Configuration should be supported by an Audit Trail, and should be able to determine if configuration has changed by level, category, and for the individual value in order to support cacheing. A configuration value has a definition to identify its usage, and a enum that identifies if a change will require a restart and what level of restart is required if the value changes. If a restart is required, both the currently running value and the value after restart should be accessible. This means that historical values of the Configuration Settings should be accessible.
Physical Name Attribute/Column Name Definition Physical Data Type
cfg_ctgy_id Configuration Category Id A Foreign Key to the Configuration Category table. bigint
cfg_setting_const Configuration Setting Constant The constant name of the Configuration Setting Constant, which can be aligned with an enumeration or other compile time constant value for access in Java. varchar(255)
dflt_setting_label Default Setting Label The name of the Configuration Setting. varchar(255)
dflt_setting_descr Default Setting Description The description of the purpose and usage of the configuration setting. This description serves for documentation, and will be used to help develop UI strings for the Label, ToolTip, Helptext etc. of the UI for the configuration setting. varchar(255)
cfg_setting_id Configuration Setting Id The automatically generated primary key of the cfg_setting table. bigint
agent_only Agent Only Indicates if Agent Only. bit
unique_user_only Unique User Only Indicates if Unique User Only. bit
cfg_val_list_id Configuration Value List Id A Foreign Key to the Configuration Value List table. bigint
val_type_cd Value Type Code The data type for a Configuration Setting. The choices are 'S' string, 'D' date, 'T' text, 'L' Long, 'R' real, and 'A' for any type. char(1)
cfg_list_type_name Configuration List Type Name The unique string identifier for an instance of Configuration List 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)
spec_class_name Specification Class Name The value of a Configuration Setting, stored as a string. varchar(255)
cfg_is_val_mapped Configuration Is Value Mapped Indicates if Configuration Is Value Mapped. bit
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.
Physical Name Attribute/Column Name Definition Physical Data Type
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)
addr_book_entry Contact Item true true A contact that belongs to the FootPrints address book. This could be implemented as a specialization of Item which has the needed features of flexible schema, and data mapping adapters.

Physical Name Attribute/Column Name Definition Physical Data Type
item_id Item Id A Foreign Key to the Item table. bigint
master_cntc_item_id Master Contact Item Id A Foreign Key to the Master Contact Item table. BIGINT
cntnr Container true true The highest abstract level of Runtime Object. The Runtime object has a cooresponding definition that acts as a catalog of the Runtime Entity. There is a hierarchy or composition concept in the Runtime Entity, but it may not be necessary to actually have navigable properties.
Physical Name Attribute/Column Name Definition Physical Data Type
cntnr_name Container Name The name of the Container. varchar(255)
cntnr_id Container Id The automatically generated primary key of the cntnr table. bigint
tenant_parttn_id Tenant Partition Id A Foreign Key to the Tenant Partition table. bigint
defn_id Definition Id A Foreign Key to the Definition table. bigint
cntnr_defn Container Definition true true The definition of a Container and the associated Configuration_Settings at the container level. This would include the collection of Item Definitions. The Container_Definition will have a Container Class identifier (Workspace, CMDB, Address Book) and may have specializations such as Workspace_Container_Definition. As much as possible, the Container Definition will suffice to describe any Container Type. There will be an association to a default Container Template, as well as more application specific Container Templates that can be chosen to initially populate the Container Template. There will also be Container Group Definition, and Container Group Templates. See the database views v_cntnr_defn, v_cntnr_defn_active.
Physical Name Attribute/Column Name Definition Physical Data Type
db_schema_name Database Schema Name The name of the database schema. It is a database object name, limited to 30 characters in length. varchar(30)
defn_id Definition Id A Foreign Key to the Definition table. bigint
cntnr_grp_defn Container Group Definition true true The definition of a Group Container and the associated Configuration_Settings at the container level. This would include the reason for the grouping and the types of containers in the group.
Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id A Foreign Key to the Definition table. bigint
cntnr_grp_reln Container Group Relationship true true The container group may exist in the runtime environment. It may suffice to have the Definition of the container group.
Physical Name Attribute/Column Name Definition Physical Data Type
cntnr_grp_reln_id Container Group Relationship Id The automatically generated primary key of the cntnr_grp_reln table. bigint
cntnr_home_page Container Home Page true true The homepage is the URL or local file that automatically loads when a web browser starts or when the browser's "home" button is pressed.
Physical Name Attribute/Column Name Definition Physical Data Type
app_ele_id Application Element Id A Foreign Key to the Application Element table. bigint
cust Customer true true a user authorized to use the FootPrints customer functions. This includes the ability to enter requests, and interact with requests as they are worked by Agents.
Physical Name Attribute/Column Name Definition Physical Data Type
cust_login_type_id Customer Login Type Id A Foreign Key to the Customer Login Type table. int
app_user_id Application User Id A Foreign Key to the Application User table. bigint
db_obj Database Object true true Database objects are the components that save and query information. A database contains several objects that are used to provide storage and display large, relational data. The main objects of a database are tables, stored procedures, views, users and functions.
db_obj_defn Database Object Definition true true The database definition object that links to configuration settings and properties to determine the functionality of a database item.
Database objects are the components that save and query information. A database contains several objects that are used to provide storage and display large, relational data. The main objects of a database are tables, stored procedures, views, users and functions.

Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id A Foreign Key to the Definition table. bigint
dflt_rule Default Rule true true A default rule is a statement that defines or constrains some aspect of the business. It is intended to assert business structure or to control or influence the behavior of the business.
Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id A Foreign Key to the Definition table. bigint
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.
Physical Name Attribute/Column Name Definition Physical Data Type
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)
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.
Physical Name Attribute/Column Name Definition Physical Data Type
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
defn_type Definition Type false The scope of the Template chosen from Instance, Container Group, Container, Item, Field.
Physical Name Attribute/Column Name Definition Physical Data Type
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_type_descr Definition Type Description A descriptive name of the Definition Type. This descriptive name may be localized. varchar(512)
defn_ver Definition Version false A version of a Definition with a version identifier that changes when data changes are made to the template. The definition version will suffice to store the current state of the FootPrints Configuration. A full copy of the definition tree is versioned when a container is published. See the database views v_defn_ver_active, v_cntnr_item_field.
Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id A Foreign Key to the Definition table. bigint
defn_ver_id Definition Version Id The automatically generated primary key of the defn_ver table. bigint
defn_ver_name Definition Version Name The name of the Definition Version. nvarchar(4000)
defn_ver_status_id Definition Version Status Id A Foreign Key to the Definition Version Status table. int
defn_ver_guid Definition Version GUID A Global Unique IDentifier search key for the Definition Version, composed of letters and numbers. It is computed by the client and typically used in unstructured data. varchar(50)
event Event true true An event is an action that is usually initiated outside the FootPrints application and that is handled by a piece of code inside the program.
event_wkflw_proc_defn Event Workflow Process Definition false
Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id A Foreign Key to the Definition table. bigint
extl_data_source_defn External Data Source Definition true true The abstraction of the structural and behaviaral source information that is configuarable by the system designer and/or the end user at definition time that specifies the file or other data source used for input or archiving.
extl_data_source_defn_db_obj_d External Data Source Definition Database Object Definition false
Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id A Foreign Key to the Definition table. bigint
field_dtype Field Datatype true true The type of field (i.e. a custom field that the users have defined).
Physical Name Attribute/Column Name Definition Physical Data Type
field_dtype_id Field Datatype Id The automatically generated primary key of the field_dtype table. bigint
field_dtype_name Field Datatype Name The name of the Field Datatype. varchar(255)
field_defn Field Definition true true The definition of a Field, including persistence information and default UI information. Some fields will be defined as database fields, and other fields will be defined as calculated fields. The field will have data types and associations to business rule definitions. Some fields are built-in, some are defaults from templates, and some are custom fields. See the database view v_cntnr_item_field.
Physical Name Attribute/Column Name Definition Physical Data Type
field_dtype_id Field Datatype Id A Foreign Key to the Field Datatype table. bigint
field_col_name Field Column Name The name of the DBMS_Object_Name. It is a database object name, limited to 30 characters in length. varchar(30)
field_descr Field Description Field Description. varchar(255)
field_defn_id Field Definition Id A Foreign Key to the Definition table. bigint
field_dpncy_rule Field Dependency Rule true true A field dependency rule constrains some aspect of the associated field. It is intended to assert business structure or to control or influence the behavior of the business.
Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id A Foreign Key to the Definition table. bigint
inbd_email Inbound Email true true A record of an email received by Footprints via a configured account. Generally, the email is deleted from the email system after successful processing.
item Item true true The Item is the abstract class for Issue, Configuration Item, Address Book entry, and other information items that are the main information entities in FootPrints. The Item structure and behavior is defined by its Definition. The Item is namespaced, identified by, and logically stored in the single parent container. It can be referenced in the same manner both inside and outside the container. The Item is the storage model and the implementation for the Item Definition. There are many important specializations of the Item class, and there even more Template definitions of Container/Item that provide an end-user application experience to the End-User. The Item implementation must implement flexible schema in an easy to manage, well engineered, and high performing way. The item can store user-defined and user-named fields defined in its definition. The Item could implement the nice-to-have features such as an inheritance model for Item subtypes, and have the ability to represent collections of subordinate items. The Item data can be imported, exported, or synchronized with external data sources. The Item data can be linked and synchronized with other items in the same Instance.
Physical Name Attribute/Column Name Definition Physical Data Type
item_key Item Key A search key for the Item, composed of letters and numbers. varchar(255)
item_id Item Id The automatically generated primary key of the item table. bigint
cntnr_id Container Id A Foreign Key to the Container table. bigint
item_defn_id Item Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
item_defn Item Definition true true The definition of an Item, which includes the Item Name and localizations and the collection of Item Fields. It also includes customizations and localizations of string resources for Item Names, and Item Field names.
Physical Name Attribute/Column Name Definition Physical Data Type
item_table_name Item Table Name The name of the DBMS_Object_Name. It is a database object name, limited to 30 characters in length. varchar(30)
item_defn_id Item Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
item_field Item Field true true A place related to a specific item that stores or displays data.
Physical Name Attribute/Column Name Definition Physical Data Type
item_id Item Id A Foreign Key to the Item table. bigint
item_field_defn Item Field Definition true true Item Field Definition is an association between the Item Definition entity and the Field Definition entity. This association contains a distinct value for each of the intersection points between the two entities.
Physical Name Attribute/Column Name Definition Physical Data Type
item_field_defn_id Item Field Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
item_defn_id Item Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
field_defn_id Field Definition Id A Foreign Key to the Definition table. bigint
item_reln Item Relationship false An Item Relationship is a relationship between instances contained in two Dynamic Object generated Tables. For example, the following. A Configuration Item Type ("Computer") related to an Workspace Item ("Incident"). An Address Book Entry ("Contact") related to another Address Book Entry ("Master Contact"). A Dynamic Link between an Incident in Workspace 1 ("Current Tickets") and Workspace 3 ("Archive Workspace").
A Dynamic Link between an Incident in Workspace 1 ("Current Tickets") and Workspace 5 ("Change Management"). There are no foreign keys defined.
Physical Name Attribute/Column Name Definition Physical Data Type
item_reln_id Item Relationship Id The automatically generated primary key of the item_reln table. bigint
item_reln_defn_id Item Relationship Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
from_item_defn_id From Item Definition Id A Foreign Key to the Definition table for an instance of type Item Definition. bigint
to_item_defn_id To Item Definition Id A Foreign Key to the Definition table for an instance of type Item Definition. bigint
link_type_defn_ver_id Link Type Definition Version Id A Foreign Key to the Definition Version table for an instance of type Link Type Definition Version. The link type will hold the configurable properties for the relationship. bigint
from_item_id From Item Id The From Item Id in the relationship. bigint
to_item_id To Item Id The To Item Id in the relationship. bigint
item_vote Item Vote true true The record of a vote on a specific item. The current effective vote is maintained here, history of conflicting changes is in the Audit Trail.
Physical Name Attribute/Column Name Definition Physical Data Type
item_id Item Id A Foreign Key to the Item table. bigint
knowledge_base_cntnr Knowledge Base Container true true A container for knowledge base information.
Physical Name Attribute/Column Name Definition Physical Data Type
cntnr_type_id Container Type Id A Foreign Key to the Container Type table. int
cntnr_id Container Id A Foreign Key to the Container table. bigint
lic_type License Type false A lookup table for the type of FootPrints license. Must be secure from tampering.
Physical Name Attribute/Column Name Definition Physical Data Type
lic_type_id License Type Id The automatically generated primary key of the lic_type table. bigint
locale Locale false A language and locale used to identify a specific dialect. It is used to determine variable forms of words, idioms, numeric format, date format, images, colors, etc. "en-US" for example is United States English, "es-LA" for Latin American Spanish.
Physical Name Attribute/Column Name Definition Physical Data Type
locale_cd Locale Code A well-known string identifier used as a code to identify the Locale. varchar(255)
locale_name Locale Name The name of the Locale. varchar(255)
locale_id Locale Id The automatically generated primary key of the locale table. bigint
is_sys_flag Is System Flag Indicates if Is System Flag. bit
local_col Localized Column false (Not used, but referenced in Java code that must be removed before table deletion.) (Not currently used. Data localization is implemented in Configuration Setting Value. May be retired in the future). A Database Column name used in the Transparent Database Localization pattern. The data in the column is the original data for which a translated value can exist. In the case of English, this is a little strange because the English translation can be different than the original data.
Physical Name Attribute/Column Name Definition Physical Data Type
app_ele_id Application Element Id A Foreign Key to the Application Element table. bigint
schema_name Schema Name The name of the Schema containing the Localized table. In Internal systems and in Definition level systems, this will be the logical name "FP", " FP Workspace", but in the Runtime system, this will be "FP 01" , "FP 01 Workspace 001" for example. varchar(30)
table_name Table Name The name of the Localized Table. varchar(30)
col_name Column Name The name of the DBMS_Object_Name. It is a database object name, limited to 30 characters in length. varchar(30)
local_col_val Localized Column Value false (Not used, but referenced in Java code that must be removed before table deletion.) (Not currently used. Data localization is implemented in Configuration Setting Value. May be retired in the future). A data value from a column and row in a Localized table. The initial english value is obtained from the table, but may be modified for visual display purposes. The Primary Key identifier of the source table is used along with the table name to establish the row identity.
Physical Name Attribute/Column Name Definition Physical Data Type
app_ele_id Application Element Id A Foreign Key to the Application Element table. bigint
local_col_id Localized Column Id A Foreign Key to the Application Element table. bigint
initl_col_string_val Initial Column String Value Initial Column String Value. varchar(255)
prmry_key_id Primary Key Id The integer primary key value of the row in the named Table that is being localized. bigint
addr_book_entry Master Contact Item true true A contact that belongs to the FootPrints address book. This could be implemented as a specialization of Item which has the needed features of flexible schema, and data mapping adapters.

Physical Name Attribute/Column Name Definition Physical Data Type
master_cntc_item_id Master Contact Item Id The automatically generated primary key of the addr_book_entry table. BIGINT
metric_defn Metric Definition true true The definition of the level of service in the service level agreement.
metric_threshold Metric Threshold true true The agreed upon levels of service.
notifn Notification true true An automated email sent as a result of system activity and notification settings.
op Operation true true Pertaining to a process or series of actions for achieving a result.
op_visibility Operation Visibility true true Whether or not a user can see the operation.
outbd_email Outbound Email true true A record of an email sent by Footprints via a configured account.
prsntn_mode Presentation Mode true true A code representing the logical mode of UI presentation. The code is used to categorize UI Element size and capabilities. Examples include: "Full View", "Quick View", "Mobile View".
prod_ver Product Version true true Information on the exact software version of the Numara products installed on the system.
rqst_for_chg_item Request For Change Item true true An item that allows input or display of information regarding a request for change.
Physical Name Attribute/Column Name Definition Physical Data Type
item_id Item Id A Foreign Key to the Item table. bigint
schd Schedule false false A personal or workspace calendar in Footprints. It is used to provide easy access to work hours and settings for appointment scheduling and metric reporting. The Calendar Service maintains the system of record tables for the schedule, but those tables are too difficult and time consuming to query for trend reporting.
Physical Name Attribute/Column Name Definition Physical Data Type
schd_id Schedule Id The automatically generated primary key of the schd table. bigint
schd_name Schedule Name The name of the Schedule. varchar(255)
max_date_val Maximum Date Value The time spans are forecast out into the future as CalendarActualPeriod. This is the maximum date for which those periods are generated. datetime
time_zone_region_name Time Zone Region Name The name of the Time Zone Region for the calendar, which derives from or overrides the value used for the system or workspace. varchar(255)
cal_type_id Calendar Type Id A Foreign Key to the Calendar Type table. int
app_user_id Application User Id A Foreign Key to the Application User table. bigint
use_local_time Use Local Time Indicates that the workschedule is base on local time for the time zone region. If you want UTC time, use that as the region. bit
secuty_permsn Security Permission true true Authorization granted to access a system resource.
secuty_right Security Right true true Rights granted to access a system resource.
Physical Name Attribute/Column Name Definition Physical Data Type
app_role_id Application Role Id A Foreign Key to the Application Role table. bigint
svc_rqst Service Item true true A Service Item in a Service Portfolio container. An item representing a provided or available software service or functionality.
Physical Name Attribute/Column Name Definition Physical Data Type
item_id Item Id A Foreign Key to the Item table. bigint
svc_level_agrmt Service Level Agreement true true A service level agreement (frequently abbreviated as SLA) is a part of a service contract where the level of service is formally defined.
prob_item Service Level Target Item true true A Service Level Target Item in a Service Portfolio container.
Physical Name Attribute/Column Name Definition Physical Data Type
item_id Item Id A Foreign Key to the Item table. bigint
svc_ctlg_cntnr Service Portfolio Container true true A catalog of services that an IT user can use on service requests. This is a type of Configuration Item.
Physical Name Attribute/Column Name Definition Physical Data Type
cntnr_type_id Container Type Id A Foreign Key to the Container Type table. int
cntnr_id Container Id A Foreign Key to the Container table. bigint
soln_item Solution Item true true An item that stores the solution information for a particular issue.
Physical Name Attribute/Column Name Definition Physical Data Type
item_id Item Id A Foreign Key to the Item table. bigint
string_rsrc_val String Resource Value false The translated value of the resource.
Physical Name Attribute/Column Name Definition Physical Data Type
string_rsrc_val_id String Resource Value Id The automatically generated primary key of the string_rsrc_val table. bigint
string_val String Value The default value for the string, which can be overriden by user customization. nchar(2000)
app_ele_string_id Application Element String Id A Foreign Key to the Application Element String table. bigint
cxt_phrase Context Phrase A free-form text field in the source language (usually english) which describes the context and has any additional guidance specific to the associated locale. varchar(255)
prod_rlse_id Product Release Id A Foreign Key to the Product Release table. bigint
locale_id Locale Id A Foreign Key to the Locale table. bigint
survey_item Survey Item true true An item that allows input or display of survey information.
Physical Name Attribute/Column Name Definition Physical Data Type
item_id Item Id A Foreign Key to the Item table. bigint
sys_env System Environment true true The System Environment layer represents information about the hardware and software environment which hosts one or more Tenant Partitions. It would be used in Use Cases such as installation, moving Tenant Partitions, finding and connecting to an Tenant Partition, and performance monitoring and Tenant maintenance.
Physical Name Attribute/Column Name Definition Physical Data Type
sys_env_id System Environment Id The automatically generated primary key of the sys_env table. bigint
sys_env_name System Environment Name The name of the System Environment. varchar(255)
sys_log System Log true true Information Logged by various system components for the purpose of debugging. Generally, this information is not stored in the database because the database may not be available during error conditions.
Physical Name Attribute/Column Name Definition Physical Data Type
tenant_parttn_id Tenant Partition Id A Foreign Key to the Tenant Partition table. bigint
sys_mfgr System Manufacturer true true The System Manufacturer is the term given to the Independent Software Vendor for the FootPrints software. There is one instance of this entity. We need a term that does not include our company name or our product name so that renaming is not necessary in the event of changes. Numara Software is always the System Manufacturer, so we don't need very information much at the Instance level other than localizations. The System Manufacturer it is relevant to interfaces with the Manufacturer's other systems.
sys_prvdr System Provider true true The System Provider is a business entity that provides the hosted FootPrints application to Tenants in a multi-tenant sense. The System Provider is in the business of providing FootPrints application setup and configuration services so that the Tenant can access a live working system.
tmpl Template true true A template for a Definition, consisting of a set of properties, values and Configuration Settings. The Template has a name and other properties, and contains a reference to a Definition.
Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id A Foreign Key to the Definition table. bigint
tenant Tenant true true The Tenant is an owner of one or more FootPrints Tenant Partitions that are configured and maintained by a System Provider. A customer that purchase FootPrints is a tenant in the sense of multi-tenant architecture, even if the Tenant does not use Numara SaaS hosting and installs and maintains the system themselves.
tenant_parttn Tenant Partition true true A partition of the FootPrints product that is isolated from other partitions in both data security and design definition and configuration.
The Tenant Partition is the global layer above the Container which hosts the Definitions and the implementations of the Containers, and hosts system level information such as the Users and Roles. In current Footprints, this is the root folder and the installed schema for the database tables.
Physical Name Attribute/Column Name Definition Physical Data Type
sys_env_id System Environment Id A Foreign Key to the System Environment table. bigint
tenant_parttn_id Tenant Partition Id The automatically generated primary key of the tenant_parttn table. bigint
tenant_parttn_defn Tenant Partition Definition true true The Root Node definition object that links to configuration settings and properties and the instance level, and also has the collection of Container Definitions below it.
Physical Name Attribute/Column Name Definition Physical Data Type
db_schema_name Database Schema Name The name of the database schema. It is a database object name, limited to 30 characters in length. varchar(30)
defn_id Definition Id A Foreign Key to the Definition table. bigint
wksp_item Ticket Item true true A specialization of Item contained in a Workspace container. Workspace Items are tracked for resolution and closure, and have parties that are awaiting resolution and closure, and responsible parties that perform work against them.
Physical Name Attribute/Column Name Definition Physical Data Type
item_id Item Id A Foreign Key to the Item table. bigint
ui_ele UI Element true true The name and identity of an Application Element that appears in the User Interface.
Physical Name Attribute/Column Name Definition Physical Data Type
app_ele_id Application Element Id A Foreign Key to the Application Element table. bigint
ui_ele_defn UI Element Definition true true The UI element definition object that links to configuration settings and properties and the instance level to determine the functionality and display of a UI item.
Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id A Foreign Key to the Definition table. bigint
ui_field UI Field true true The name and identity of an application field element that appears in the User Interface.
Physical Name Attribute/Column Name Definition Physical Data Type
app_ele_id Application Element Id A Foreign Key to the Application Element table. bigint
ui_field_defn UI Field Definition true true The field UI element definition object that links to configuration settings and properties and the instance level to determine it's functionality and display.
Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id A Foreign Key to the Definition table. bigint
ui_form UI Form true true The name and identity of an application form element that appears in the User Interface.
Physical Name Attribute/Column Name Definition Physical Data Type
app_ele_id Application Element Id A Foreign Key to the Application Element table. bigint
ui_form_defn UI Form Definition true true The form UI element definition object that links to configuration settings and properties and the instance level to determine it's functionality and display.
Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id A Foreign Key to the Definition table. bigint
ui_tab UI Tab true true The name and identity of an application tab element that appears in the User Interface.
Physical Name Attribute/Column Name Definition Physical Data Type
app_ele_id Application Element Id A Foreign Key to the Application Element table. bigint
ui_tab_defn UI Tab Definition true true The tab UI element definition object that links to configuration settings and properties and the instance level to determine it's functionality and display.
Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id A Foreign Key to the Definition table. bigint
user_prefc_defn User Preference Definition true true The abstraction of the structural and behaviaral preference information that is configuarable by the system designer and/or the end user at definition time.
Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id A Foreign Key to the Definition table. bigint
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.
Physical Name Attribute/Column Name Definition Physical Data Type
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)
valid_vals_rule Valid Values Rule true true A valid values rule constrains some aspect of the Footprints application to a set or range of values. It is intended to assert business structure or to control or influence the behavior of the business.
Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id A Foreign Key to the Definition table. bigint
valdn_rule Validation Rule true true A valdation rule constrains some aspect of the associated field. It is intended to assert business structure or to control or influence the behavior of the business.
Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id A Foreign Key to the Definition table. bigint
wkflw_actn Workflow Action true true A workflow action that Footprints can take in response to Change Management activity or escalations or other system features that trigger actions. The change to a phase action for Approval, Disapproval, or Expiration can trigger any of these actions.
wkflw_proc_defn Workflow Process Definition true true The management of steps in a business processes. A workflow specifies what tasks need to be done, in what order (sometimes linearly, sometimes in parallel), and who has permission to perform each task. Most tasks are performed by humans but they can also be automated processes.
Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id A Foreign Key to the Definition table. bigint
wkflw_proc_defn_wkflw_actn Workflow Process Definition Workflow Action false
Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id A Foreign Key to the Definition table. bigint
wksp_actvy_data_mart Workspace Activity Data Mart true true A summarized data store of Workspace Activity metric calculations used to support the Executive Dashboard Trend Reporting feature in an upcoming FootPrints release. There is a version of this for both the FootPrints Monet (Perl) and Renoir (Java) releases. The data mart tables conform to a very specific star-schema design and must be populated using history data and an incremental feed. The Star Schema structure must be able to use custom Workspace Item Fields, so the design must be coordinated with the implementation of Workspace Item.
wksp_cntnr Workspace Container true true A workspace is the principle architectural structure in Numara FootPrints for storing and tracking information. A Workspace is a separate sub-database or work area within the system with its own fields, forms, options, workflow, settings and users. Most of the behaviour of the Workspace comes from the Container Abstract class, and only things that are specific to the Workspace are implemented here. For Example, Current FootPrints allows a single CMDB to be referenced from a Workspace, and a single Address book, yet these are listed as features for improvement. So convenience methods that get and set Container Group Relationship might be appropriate.

Physical Name Attribute/Column Name Definition Physical Data Type
time_zone_region_name Time Zone Region Name The name of the Time Zone Region. This is 2. The 'primary key' of the java timezone is the string region identifier in English, example 'America/Phoenix'. There is no numeric identifier. As the JRE is updated, or specific classes are updated, the list could change to include new entries, and the detail data behind the regions could change. varchar(255)
cntnr_type_id Container Type Id A Foreign Key to the Container Type table. int
cntnr_id Container Id A Foreign Key to the Container table. bigint
prob_item WorkTarget Item true true A Work Target Item in a Service Portfolio container.
Physical Name Attribute/Column Name Definition Physical Data Type
worktarget_item_id WorkTarget Item Id The automatically generated primary key of the prob_item table. BIGINT
item_id Item Id A Foreign Key to the Item table. bigint