Subject Area : 040 - Container |
# | Name | Definition | ER Diagram | Entity/Table | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | ||||||||||||||||||||||||||||||||||||||||||||||||||
. | 040 - Container | The Container is an important abstraction of the FootPrints concepts of Workspace, Address Book, CMDB, and others. The idea is that the Container has specific settings that apply to the Items that can be defined to the Container. So the Container Type allows certain Item Types. It also means that new Container Types such as Knowledge Base, Survey can be defined without having to describe them as Workspaces. | Details.. | Details.. |
# | Name | Physical Display Level | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | Logical | Column |
# | Physical Name | Name | Logical Only | Do Not Generate | Definition | Attribute/Column | ||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 7 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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.. | ||||||||||||||||||||||||||||||||||||||||||||
. | cntnr | Container | true | true | The highest abstract level of Runtime Object. The Runtime object has a cooresponding definition that acts as a catalog of the Runtime Entity. There is a hierarchy or composition concept in the Runtime Entity, but it may not be necessary to actually have navigable properties. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | cntnr_defn | Container Definition | true | true | The definition of a Container and the associated Configuration_Settings at the container level. This would include the collection of Item Definitions. The Container_Definition will have a Container Class identifier (Workspace, CMDB, Address Book) and may have specializations such as Workspace_Container_Definition. As much as possible, the Container Definition will suffice to describe any Container Type. There will be an association to a default Container Template, as well as more application specific Container Templates that can be chosen to initially populate the Container Template. There will also be Container Group Definition, and Container Group Templates. See the database views v_cntnr_defn, v_cntnr_defn_active. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | defn | Definition | false | A definition holds the structural and behavioral information needed for an application element that is configuarable by the system designer and/or the end user at definition time. Current Footrpints uses a combination of directories, files, tables, and programming code to represent this information. The new FootPrints will provide all of the same information within the definition. The definition can be persisted in a structure that is isolated at the Instance Level. The data for the definition will be stored as Configuration Settings associated with the Definition Version. See the database views v_defn_ver_active, v_cntnr_item_field. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | 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.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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.. |
# | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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 | 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 | 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 | 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 | 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 |