Subject Area : 000 - Very High Level Domain Model |
Subject Area Name | Definition | |||||
---|---|---|---|---|---|---|
000 - Very 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. The Definition is a key abstract class used to define dynamic objects that can be customized and published. Gray Objects indicate Logical Only concepts that do not correspond to unique tables but are stored in other tables. Child tables may be stored in a hierarchy, or template tables may be generated as multiple concrete tables. | |||||
ER Diagram Name | Physical Display Level | |||||
Entity Level | Column | |||||
Table Level | Table | |||||
Physical Name | Entity/Table Name | Logical Only | Do Not Generate | Definition | ||
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 | |||
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 | |||
app_user_prof_link | Application User Profile Link | false | The link between the application user and the user profile. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
user_prof_id | User Profile Id | A Foreign Key to the User Profile table. | bigint | |||
app_user_prof_link_id | Application User Profile Link Id | The automatically generated primary key of the app_user_prof_link table. | bigint | |||
app_user_id | Application User Id | A Foreign Key to the Application User table. | bigint | |||
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. | ||
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_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 | |||
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 | |||
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 | |||
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_reln | Definition Relationship | false | All relationships between definitions are stored in this table in order to make the model able to handle new relationships without changes to tables. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
defn_reln_id | Definition Relationship Id | The automatically generated primary key of the defn_reln table. | bigint | |||
from_defn_ver_id | From Definition Version Id | A Foreign Key to the Definition Version table. | bigint | |||
to_defn_ver_id | To Definition Version Id | A Foreign Key to the Definition Version table. | bigint | |||
defn_reln_type_id | Definition Relationship Type Id | A Foreign Key to the Definition Relationship Type table. | int | |||
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) | |||
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 | |||
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_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_reln_defn | Item Relationship Definition | true | true | The definition of a Relationship type within the Container Definition. This has important Configuration_Settings and Application Element Identifier values that clarify the meaning of the Relationship to programming code. | ||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
item_reln_defn_id | Item Relationship Definition Id | A Foreign Key to the Definition table for an instance of type Definition. | bigint | |||
from_mbr_role_type_id | From Member Role Type Id | char(18) | ||||
to_mbr_role_type_id | To Member Role Type Id | char(18) | ||||
reln_type_id | Relationship Type Id | Relationship type | char(18) | |||
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 | |||
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 | |||
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 | |||
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_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 | |||
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 | |||
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) | |||
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 |