Subject Area : 000 - Very High Level Domain Model
Subject Area(s) of Model "Renoir Domain Model Detail"
# Name Definition ER Diagram Entity/Table
Total
. 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. Details.. Details..
ER Diagram(s) of Subject Area "000 - Very High Level Domain Model"
# Name Physical Display Level
Total 2
. Entity Level Column
. Table Level Table
Entity/Table(s) of Subject Area "000 - Very High Level Domain Model"
# Physical Name Name Logical Only Do Not Generate Definition Attribute/Column
Total 33
. 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.

Details..
. 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. Details..
. 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. Details..
. app_role Application Role false A User Security Role within Footprints. This includes Agent Users and Customer Users, and includes Role settings at the Instance and Container level. Workspace Role and CMDB Role may both be implemented as Container Role. The Role has associated Rights and Permissions, and is a way of granting Roles and Permissions to a User. There is some conceptual overlap between the User Profile and the Role. The User is assigned a single Role as part of the User Profile, and a User can only have one System Role and one Workspace Role. The User Profile can have property settings that override the Role Settings. Details..
. 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. Details..
. app_user_prof_link Application User Profile Link false The link between the application user and the user profile. Details..
. 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. Details..
. 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. Details..
. audit_txn_audit_trail Audit Transaction Audit Trail false Details..
. 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. Details..
. 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. Details..
. 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. Details..
. 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.

Details..
. 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. Details..
. 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. Details..
. defn Definition false A definition holds the structural and behavioral information needed for an application element that is configuarable by the system designer and/or the end user at definition time. Current Footrpints uses a combination of directories, files, tables, and programming code to represent this information. The new FootPrints will provide all of the same information within the definition. The definition can be persisted in a structure that is isolated at the Instance Level. The data for the definition will be stored as Configuration Settings associated with the Definition Version. See the database views v_defn_ver_active, v_cntnr_item_field. Details..
. defn_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. Details..
. 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. Details..
. 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. Details..
. 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. Details..
. 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. Details..
. 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. Details..
. 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.
Details..
. 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. Details..
. 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. Details..
. 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. Details..
. string_rsrc_val String Resource Value false The translated value of the resource. Details..
. 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. Details..
. 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.
Details..
. 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. Details..
. user_prof User Profile false A container for Permissions and Settings (the composite parts are the associated Role and the User Preferences). The permissions for a User to access a particular container according to the capabilities defined. In most cases this will be more defined in a subcategory.
 
Example: Shared User Profile
This profile will be shared between multiple users that access the system with the same User ID.
Details..
. 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. Details..
. 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.

Details..
Attribute/Column(s) of Entity/Table "Address Book Container"
# Physical Name Name Definition Physical Data Type
Total 7
. 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
Attribute/Column(s) of Entity/Table "Application Element"
# Physical Name Name Definition Physical Data Type
Total 7
. 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
Attribute/Column(s) of Entity/Table "Application Element String"
# Physical Name Name Definition Physical Data Type
Total 5
. 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)
Attribute/Column(s) of Entity/Table "Application Role"
# Physical Name Name Definition Physical Data Type
Total 11
. app_role_id Application Role Id The automatically generated primary key of the app_role table. bigint
. tmpl_app_role_id Template Application Role Id A Foreign Key to the Application Role table. This indicates which Template Role was used to create a built-in role in case some features concerning new properties added to later release of the system will need to be added to existing templates. bigint
. app_role_name Application Role Name The name of the Application Role. varchar(255)
. defn_id Definition Id A Foreign Key to the Definition table. bigint
. admin_type_id Administrator Type Id A Foreign Key to the Administrator Type table. int
. is_built_in Is Built In Indicates that this instance of Application Role is a built-in instance that cannot be changed by the end user. bit
. app_role_descr Application Role Description A descriptive name of the Application Role. This descriptive name may be localized. varchar(1024)
. user_type_id User Type Id A Foreign Key to the User Type table. int
. defn_subtype_id Definition Subtype Id A Foreign Key to the Definition Subtype table. int
. tmpl_app_role_id Template Application Role Id A Foreign Key to the Application Role table. bigint
. tmpl_level_name tmpl_level_name The value of a Built_in_level, stored as a string. varchar(255)
Attribute/Column(s) of Entity/Table "Application User"
# Physical Name Name Definition Physical Data Type
Total 8
. 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
Attribute/Column(s) of Entity/Table "Application User Profile Link"
# Physical Name Name Definition Physical Data Type
Total 3
. 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
Attribute/Column(s) of Entity/Table "Audit Trail"
# Physical Name Name Definition Physical Data Type
Total 1
. item_id Item Id A Foreign Key to the Item table. bigint
Attribute/Column(s) of Entity/Table "Audit Transaction Audit Trail"
# Physical Name Name Definition Physical Data Type
Total 1
. item_id Item Id A Foreign Key to the Item table. bigint
Attribute/Column(s) of Entity/Table "CMDB Container"
# Physical Name Name Definition Physical Data Type
Total 2
. 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
Attribute/Column(s) of Entity/Table "Configuration Item"
# Physical Name Name Definition Physical Data Type
Total 1
. item_id Item Id A Foreign Key to the Item table. bigint
Attribute/Column(s) of Entity/Table "Configuration Setting"
# Physical Name Name Definition Physical Data Type
Total 12
. 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
Attribute/Column(s) of Entity/Table "Contact Item"
# Physical Name Name Definition Physical Data Type
Total 2
. 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
Attribute/Column(s) of Entity/Table "Container"
# Physical Name Name Definition Physical Data Type
Total 4
. 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
Attribute/Column(s) of Entity/Table "Container Definition"
# Physical Name Name Definition Physical Data Type
Total 2
. 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
Attribute/Column(s) of Entity/Table "Definition"
# Physical Name Name Definition Physical Data Type
Total 7
. defn_id Definition Id The automatically generated primary key of the defn table. bigint
. defn_name Definition Name The name of the Definition. nvarchar(4000)
. dsble_date Disabled Date The date that this instance of Definition is logically deleted and disabled. datetime
. defn_guid Definition GUID A Global Unique IDentifier search key for the Definition, composed of letters and numbers. It is computed by the client and typically used in unstructured data. varchar(50)
. defn_type_name Definition Type Name The unique string identifier for an instance of Definition Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. varchar(255)
. defn_subtype_id Definition Subtype Id A Foreign Key to the Definition Subtype table. int
. tmpl_export_guid Template Export GUID The value of a Definition, stored as a string. VARCHAR(50)
Attribute/Column(s) of Entity/Table "Definition Relationship"
# Physical Name Name Definition Physical Data Type
Total 4
. 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
Attribute/Column(s) of Entity/Table "Definition Version"
# Physical Name Name Definition Physical Data Type
Total 5
. 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)
Attribute/Column(s) of Entity/Table "Field Definition"
# Physical Name Name Definition Physical Data Type
Total 4
. 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
Attribute/Column(s) of Entity/Table "Item"
# Physical Name Name Definition Physical Data Type
Total 4
. 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
Attribute/Column(s) of Entity/Table "Item Definition"
# Physical Name Name Definition Physical Data Type
Total 2
. 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
Attribute/Column(s) of Entity/Table "Item Field Definition"
# Physical Name Name Definition Physical Data Type
Total 3
. 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
Attribute/Column(s) of Entity/Table "Item Relationship"
# Physical Name Name Definition Physical Data Type
Total 7
. 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
Attribute/Column(s) of Entity/Table "Item Relationship Definition"
# Physical Name Name Definition Physical Data Type
Total 4
. 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)
Attribute/Column(s) of Entity/Table "Locale"
# Physical Name Name Definition Physical Data Type
Total 4
. 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
Attribute/Column(s) of Entity/Table "Schedule"
# Physical Name Name Definition Physical Data Type
Total 7
. 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
Attribute/Column(s) of Entity/Table "String Resource Value"
# Physical Name Name Definition Physical Data Type
Total 6
. 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
Attribute/Column(s) of Entity/Table "Template"
# Physical Name Name Definition Physical Data Type
Total 1
. defn_id Definition Id A Foreign Key to the Definition table. bigint
Attribute/Column(s) of Entity/Table "Tenant Partition"
# Physical Name Name Definition Physical Data Type
Total 2
. 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
Attribute/Column(s) of Entity/Table "Ticket Item"
# Physical Name Name Definition Physical Data Type
Total 1
. item_id Item Id A Foreign Key to the Item table. bigint
Attribute/Column(s) of Entity/Table "User Profile"
# Physical Name Name Definition Physical Data Type
Total 15
. user_prof_id User Profile Id The automatically generated primary key of the user_prof table. bigint
. tmpl_user_prof_id Template User Profile Id A Foreign Key to the User Profile table. This will not be a navigable key in the object model. This indicates which Template User Profile was used to create a built-in template in case some features concerning new properties added to later release of the system will need to be added to existing templates. bigint
. role_grp_id Role Group Id A Foreign Key to the Role Group table. A system level user profile can have a role group, which will have the effect of assigning a collection of workspace, cmdb, and address book roles at the container role level. bigint
. defn_id Definition Id A Foreign Key to the Definition table. Optionally, the container that owns the profile. bigint
. app_role_id Application Role Id A Foreign Key to the Application Role table. The User Profile is the means for setting the default role at the system and workspace levels, and is also the role of a Unique User Profile tied to a application user. bigint
. agent_authcn_type_id Agent Authentication Type Id A Foreign Key to the Agent Authentication Type table. int
. user_prof_name User Profile Name The name of the User Profile. varchar(255)
. is_built_in Is Built In Indicates that this instance of User Profile is a built-in instance that cannot be changed by the end user. bit
. user_type_id User Type Id A Foreign Key to the User Type table. int
. cust_authcn_type_id Customer Authentication Type Id A Foreign Key to the Customer Authentication Type table. int
. is_sys Is System Indicates if this is a system level profile. bit
. defn_subtype_id Definition Subtype Id A Foreign Key to the Definition Subtype table. int
. delete_date Delete Date The value of a User Profile, stored as a date. datetime
. last_login Last Login date time of last login in UTC. datetime
. tmpl_level_name tmpl_level_name The value of a Built_in_level, stored as a string. varchar(255)
Attribute/Column(s) of Entity/Table "Workspace Container"
# Physical Name Name Definition Physical Data Type
Total 3
. 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