Subject Area : 001 - High Level Domain Model |
# | Name | Definition | ER Diagram | Entity/Table | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | ||||||||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | Details.. |
# | Name | Physical Display Level | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | Entity Level | Column | ||||||||||||||||||||||||||||||||||||||||||||||||
. | Table Level | Table |
# | Physical Name | Name | Logical Only | Do Not Generate | Definition | Attribute/Column | ||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 100 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | actvy_defn | Activity Definition | true | true |
The definition of a task that must take place in order to fulfill an operation contract. |
Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | 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.. | |||||||||||||||||||||||||||||||||||||||||||||
. | 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.. | ||||||||||||||||||||||||||||||||||||||||||||
. | asset_item | Asset Item | true | true | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | attch_inbd_email | Attachment Inbound Email | false | Details.. | ||||||||||||||||||||||||||||||||||||||||||||||
. | attch_outbd_email | Attachment Outbound Email | false | 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 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 | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | audit_txn_audit_trail | Audit Transaction Audit Trail | false | Details.. | ||||||||||||||||||||||||||||||||||||||||||||||
. | 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. | 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.. | |||||||||||||||||||||||||||||||||||||||||||||
. | cfg_setting_val | Configuration Setting Value | false | Configuration Setting Value is an association between the Configuration Setting entity and a container entity (i.e. User Profile, Role, and Definition). This association contains a distinct value for each of the intersection points between the two entities. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | 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.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. |
Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | defn | Definition | false | A definition holds the structural and behavioral information needed for an application element that is configuarable by the system designer and/or the end user at definition time. Current Footrpints uses a combination of directories, files, tables, and programming code to represent this information. The new FootPrints will provide all of the same information within the definition. The definition can be persisted in a structure that is isolated at the Instance Level. The data for the definition will be stored as Configuration Settings associated with the Definition Version. See the database views v_defn_ver_active, v_cntnr_item_field. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | defn_subtype | Definition Subtype | false | The subtype of the definition used as a discriminator for the class of definition. Each subtype will have different configuration settings and associated definitions. These include associated built-in field definitions for item subtypes. See the database view v_defn_subtype. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | defn_type | Definition Type | false | The scope of the Template chosen from Instance, Container Group, Container, Item, Field. | 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.. | |||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | event_wkflw_proc_defn | Event Workflow Process Definition | false | Details.. | ||||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | extl_data_source_defn_db_obj_d | External Data Source Definition Database Object Definition | false | Details.. | ||||||||||||||||||||||||||||||||||||||||||||||
. | field_dtype | Field Datatype | true | true | The type of field (i.e. a custom field that the users have defined). | 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.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | 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 | Item Field | true | true | A place related to a specific item that stores or displays data. | 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_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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | knowledge_base_cntnr | Knowledge Base Container | true | true | A container for knowledge base information. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | lic_type | License Type | false | A lookup table for the type of FootPrints license. Must be secure from tampering. | 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.. | |||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | 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. |
Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | metric_defn | Metric Definition | true | true | The definition of the level of service in the service level agreement. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | metric_threshold | Metric Threshold | true | true | The agreed upon levels of service. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | notifn | Notification | true | true | An automated email sent as a result of system activity and notification settings. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | op | Operation | true | true | Pertaining to a process or series of actions for achieving a result. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | op_visibility | Operation Visibility | true | true | Whether or not a user can see the operation. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | outbd_email | Outbound Email | true | true | A record of an email sent by Footprints via a configured account. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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". | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | prod_ver | Product Version | true | true | Information on the exact software version of the Numara products installed on the system. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | rqst_for_chg_item | Request For Change Item | true | true | An item that allows input or display of information regarding a request for change. | 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.. | ||||||||||||||||||||||||||||||||||||||||||||
. | secuty_permsn | Security Permission | true | true | Authorization granted to access a system resource. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | secuty_right | Security Right | true | true | Rights granted to access a system resource. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | prob_item | Service Level Target Item | true | true | A Service Level Target Item in a Service Portfolio container. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | soln_item | Solution Item | true | true | An item that stores the solution information for a particular issue. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | string_rsrc_val | String Resource Value | false | The translated value of the resource. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | survey_item | Survey Item | true | true | An item that allows input or display of survey information. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | 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 | 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. | 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.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | 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.. | ||||||||||||||||||||||||||||||||||||||||||||
. | ui_ele | UI Element | true | true | The name and identity of an Application Element that appears in the User Interface. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | ui_field | UI Field | true | true | The name and identity of an application field element that appears in the User Interface. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | ui_form | UI Form | true | true | The name and identity of an application form element that appears in the User Interface. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | ui_tab | UI Tab | true | true | The name and identity of an application tab element that appears in the User Interface. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | 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.. | |||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | wkflw_proc_defn_wkflw_actn | Workflow Process Definition Workflow Action | false | 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.. | ||||||||||||||||||||||||||||||||||||||||||||
. | prob_item | WorkTarget Item | true | true | A Work Target Item in a Service Portfolio container. | Details.. |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | A Foreign Key to the Definition table. | bigint |
# | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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 |
# | 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 |
# | 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) |
# | 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) |
# | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | item_id | Item Id | A Foreign Key to the Item table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | item_id | Item Id | A Foreign Key to the Item table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | item_id | Item Id | A Foreign Key to the Item table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | A Foreign Key to the Definition table. | bigint |
# | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | item_id | Item Id | A Foreign Key to the Item table. | bigint |
# | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 13 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | cfg_setting_val_id | Configuration Setting Value Id | The automatically generated primary key of the cfg_setting_val table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | cfg_setting_id | Configuration Setting Id | A Foreign Key to the Configuration Setting table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | val_type_cd | Value Type Code | The data type for a Configuration Setting Value. The choices are 'S' string, 'D' date, 'T' text, 'I' integer. | char(1) | ||||||||||||||||||||||||||||||||||||||||||||||
. | string_val | String Value | The value of a Configuration Setting Value, stored as a string. | nvarchar(4000) | ||||||||||||||||||||||||||||||||||||||||||||||
. | text_val | Text Value | The value of a Configuration Setting Value, stored as a long text object. | nvarchar(max) | ||||||||||||||||||||||||||||||||||||||||||||||
. | real_val | Real Value | The value of a Configuration Setting Value stored as a real. | numeric(38,20) | ||||||||||||||||||||||||||||||||||||||||||||||
. | long_val | Long Value | The value of a Configuration Setting Value stored as Long. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | date_val | Date Value | The value of a Configuration Setting Value, stored as a date. | datetime | ||||||||||||||||||||||||||||||||||||||||||||||
. | boolean_val | Boolean Value | The value of a Configuration Setting Value stored as Boolean. | bit | ||||||||||||||||||||||||||||||||||||||||||||||
. | int_val | Int Value | The value of a Configuration Setting Value stored as Int. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | owner_id | Owner Id | A Foreign Key to the Owning instance in either the Definition, Definition Version , Role, or User Profile tables. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | val_map_key | Value Map Key | The value of a Configuration Setting Value, stored as a string. | varchar(255) | ||||||||||||||||||||||||||||||||||||||||||||||
. | cfg_setting_owner_type_name | Configuration Setting Owner Type Name | The unique string identifier for an instance of Configuration Setting Owner Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. | varchar(255) |
# | 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 |
# | 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 |
# | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | A Foreign Key to the Definition table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | cntnr_grp_reln_id | Container Group Relationship Id | The automatically generated primary key of the cntnr_grp_reln table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | app_ele_id | Application Element Id | A Foreign Key to the Application Element table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | A Foreign Key to the Definition table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | A Foreign Key to the Definition table. | bigint |
# | 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) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 6 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_subtype_name | Definition Subtype Name | The name of the Definition Subtype. | varchar(255) | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_subtype_descr | Definition Subtype Description | A descriptive name of the Definition Subtype. This descriptive name may be localized. | varchar(512) | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_subtype_id | Definition Subtype Id | The automatically generated primary key of the defn_subtype table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_parent_subtype_id | definition parent subtype id | A Foreign Key to the Definition Subtype table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_type_name | Definition Type Name | The unique string identifier for an instance of Definition Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. | varchar(255) | ||||||||||||||||||||||||||||||||||||||||||||||
. | max_in_parent | Maximum In Parent | A Foreign Key to the Definition Subtype table. | int |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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) |
# | 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) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | A Foreign Key to the Definition table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | A Foreign Key to the Definition table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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) |
# | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | A Foreign Key to the Definition table. | bigint |
# | 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 |
# | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | item_id | Item Id | A Foreign Key to the Item table. | bigint |
# | 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 |
# | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | item_id | Item Id | A Foreign Key to the Item table. | bigint |
# | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | lic_type_id | License Type Id | The automatically generated primary key of the lic_type table. | bigint |
# | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | master_cntc_item_id | Master Contact Item Id | The automatically generated primary key of the addr_book_entry table. | BIGINT |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | item_id | Item Id | A Foreign Key to the Item table. | bigint |
# | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | app_role_id | Application Role Id | A Foreign Key to the Application Role table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | item_id | Item Id | A Foreign Key to the Item table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | item_id | Item Id | A Foreign Key to the Item table. | bigint |
# | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | item_id | Item Id | A Foreign Key to the Item table. | bigint |
# | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | item_id | Item Id | A Foreign Key to the Item table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | tenant_parttn_id | Tenant Partition Id | A Foreign Key to the Tenant Partition table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | A Foreign Key to the Definition table. | bigint |
# | 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 |
# | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | item_id | Item Id | A Foreign Key to the Item table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | app_ele_id | Application Element Id | A Foreign Key to the Application Element table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | A Foreign Key to the Definition table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | app_ele_id | Application Element Id | A Foreign Key to the Application Element table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | A Foreign Key to the Definition table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | app_ele_id | Application Element Id | A Foreign Key to the Application Element table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | A Foreign Key to the Definition table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | app_ele_id | Application Element Id | A Foreign Key to the Application Element table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | A Foreign Key to the Definition table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | A Foreign Key to the Definition table. | bigint |
# | 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) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | A Foreign Key to the Definition table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | A Foreign Key to the Definition table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | A Foreign Key to the Definition table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | A Foreign Key to the Definition table. | bigint |
# | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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 |