Subject Area : 041 - Definition Detail |
Subject Area Name | Definition | |||||
---|---|---|---|---|---|---|
041 - Definition Detail | A detailed look at the tables needed to store a definition. The idea is that all dynamic objects can share the functionality of having versions, being published, and participating in relationships with other definitions. A new definition type can be added to the Java code without affecting the database storage. | |||||
ER Diagram Name | Physical Display Level | |||||
Logical | Column | |||||
Physical | Column | |||||
Physical Name | Entity/Table Name | Logical Only | Do Not Generate | Definition | ||
association_type | Association Type | false | ||||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
association_type_id | Association Type Id | The automatically generated primary key of the association_type table. | bigint | |||
association_type_name | Association Type Name | The name of the Association Type. | varchar(255) | |||
association_type_descr | Association Type Description | A descriptive name of the Association Type. This descriptive name may be localized. | varchar(512) | |||
cntnr_defn | Container Definition | true | true | The definition of a Container and the associated Configuration_Settings at the container level. This would include the collection of Item Definitions. The Container_Definition will have a Container Class identifier (Workspace, CMDB, Address Book) and may have specializations such as Workspace_Container_Definition. As much as possible, the Container Definition will suffice to describe any Container Type. There will be an association to a default Container Template, as well as more application specific Container Templates that can be chosen to initially populate the Container Template. There will also be Container Group Definition, and Container Group Templates. See the database views v_cntnr_defn, v_cntnr_defn_active. | ||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
db_schema_name | Database Schema Name | The name of the database schema. It is a database object name, limited to 30 characters in length. | varchar(30) | |||
defn_id | Definition Id | A Foreign Key to the Definition table. | bigint | |||
defn | Definition | false | A definition holds the structural and behavioral information needed for an application element that is configuarable by the system designer and/or the end user at definition time. Current Footrpints uses a combination of directories, files, tables, and programming code to represent this information. The new FootPrints will provide all of the same information within the definition. The definition can be persisted in a structure that is isolated at the Instance Level. The data for the definition will be stored as Configuration Settings associated with the Definition Version. See the database views v_defn_ver_active, v_cntnr_item_field. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
defn_id | Definition Id | The automatically generated primary key of the defn table. | bigint | |||
defn_name | Definition Name | The name of the Definition. | nvarchar(4000) | |||
dsble_date | Disabled Date | The date that this instance of Definition is logically deleted and disabled. | datetime | |||
defn_guid | Definition GUID | A Global Unique IDentifier search key for the Definition, composed of letters and numbers. It is computed by the client and typically used in unstructured data. | varchar(50) | |||
defn_type_name | Definition Type Name | The unique string identifier for an instance of Definition Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. | varchar(255) | |||
defn_subtype_id | Definition Subtype Id | A Foreign Key to the Definition Subtype table. | int | |||
tmpl_export_guid | Template Export GUID | The value of a Definition, stored as a string. | VARCHAR(50) | |||
defn_reln | Definition Relationship | false | All relationships between definitions are stored in this table in order to make the model able to handle new relationships without changes to tables. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
defn_reln_id | Definition Relationship Id | The automatically generated primary key of the defn_reln table. | bigint | |||
from_defn_ver_id | From Definition Version Id | A Foreign Key to the Definition Version table. | bigint | |||
to_defn_ver_id | To Definition Version Id | A Foreign Key to the Definition Version table. | bigint | |||
defn_reln_type_id | Definition Relationship Type Id | A Foreign Key to the Definition Relationship Type table. | int | |||
defn_reln_type | Definition Relationship Type | false | The Definition Relationship Type entity depicts a set of relationships that a Definition instance in the system can have with another Definition instance(i.e. parent_child indicatesto a hierarchical relationship) . This specific relationship is further clarified when combined with the Definition Relationship Member Type entity. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
defn_reln_type_name | Definition Relationship Type Name | The name of the Definition Relationship Type. | varchar(255) | |||
defn_reln_type_id | Definition Relationship Type Id | The automatically generated primary key of the defn_reln_type table. | int | |||
defn_reln_type_descr | Definition Relationship Type Description | A descriptive name of the Definition Relationship Type. This descriptive name may be localized. | varchar(512) | |||
defn_subtype | Definition Subtype | false | The subtype of the definition used as a discriminator for the class of definition. Each subtype will have different configuration settings and associated definitions. These include associated built-in field definitions for item subtypes. See the database view v_defn_subtype. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
defn_subtype_name | Definition Subtype Name | The name of the Definition Subtype. | varchar(255) | |||
defn_subtype_descr | Definition Subtype Description | A descriptive name of the Definition Subtype. This descriptive name may be localized. | varchar(512) | |||
defn_subtype_id | Definition Subtype Id | The automatically generated primary key of the defn_subtype table. | int | |||
defn_parent_subtype_id | definition parent subtype id | A Foreign Key to the Definition Subtype table. | int | |||
defn_type_name | Definition Type Name | The unique string identifier for an instance of Definition Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. | varchar(255) | |||
max_in_parent | Maximum In Parent | A Foreign Key to the Definition Subtype table. | int | |||
defn_type | Definition Type | false | The scope of the Template chosen from Instance, Container Group, Container, Item, Field. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
defn_type_name | Definition Type Name | The unique string identifier for an instance of Definition Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. | varchar(255) | |||
defn_type_descr | Definition Type Description | A descriptive name of the Definition Type. This descriptive name may be localized. | varchar(512) | |||
defn_ver | Definition Version | false | A version of a Definition with a version identifier that changes when data changes are made to the template. The definition version will suffice to store the current state of the FootPrints Configuration. A full copy of the definition tree is versioned when a container is published. See the database views v_defn_ver_active, v_cntnr_item_field. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
defn_id | Definition Id | A Foreign Key to the Definition table. | bigint | |||
defn_ver_id | Definition Version Id | The automatically generated primary key of the defn_ver table. | bigint | |||
defn_ver_name | Definition Version Name | The name of the Definition Version. | nvarchar(4000) | |||
defn_ver_status_id | Definition Version Status Id | A Foreign Key to the Definition Version Status table. | int | |||
defn_ver_guid | Definition Version GUID | A Global Unique IDentifier search key for the Definition Version, composed of letters and numbers. It is computed by the client and typically used in unstructured data. | varchar(50) | |||
defn_ver_association | Definition Version Association | false | ||||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
defn_ver_association_id | Definition Version Association Id | The automatically generated primary key of the defn_ver_association table. | bigint | |||
from_defn_ver_id | From Definition Version ID | A Foreign Key to the Definition Version table. | bigint | |||
to_defn_ver_id | To Definition Version ID | A Foreign Key to the Definition Version table. | bigint | |||
association_type_id | Association Type Id | A Foreign Key to the Association Type table. | bigint | |||
defn_ver_status | Definition Version Status | false |
The attribute of the definition version entity that tells what state the definition instance is in. The word "Published" in this context means a change being commited or made ready for runtime. Currently the available status options are: Draft Dirty - the entity instance is being created or changed, but has not yet been published, so is not yet valid for runtime. Published Active - the entity instance has been published, and is available for runtime. Published Outdated - the entity instance has been previously published, but has been replaced with a newer version of itself in runtime. |
|||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
defn_ver_status_name | Definition Version Status Name | The name of the Definition Version Status. | varchar(255) | |||
defn_ver_status_id | Definition Version Status Id | The automatically generated primary key of the defn_ver_status table. | int | |||
field_dtype | Field Datatype | true | true | The type of field (i.e. a custom field that the users have defined). | ||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
field_dtype_id | Field Datatype Id | The automatically generated primary key of the field_dtype table. | bigint | |||
field_dtype_name | Field Datatype Name | The name of the Field Datatype. | varchar(255) | |||
field_defn | Field Definition | true | true | The definition of a Field, including persistence information and default UI information. Some fields will be defined as database fields, and other fields will be defined as calculated fields. The field will have data types and associations to business rule definitions. Some fields are built-in, some are defaults from templates, and some are custom fields. See the database view v_cntnr_item_field. | ||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
field_dtype_id | Field Datatype Id | A Foreign Key to the Field Datatype table. | bigint | |||
field_col_name | Field Column Name | The name of the DBMS_Object_Name. It is a database object name, limited to 30 characters in length. | varchar(30) | |||
field_descr | Field Description | Field Description. | varchar(255) | |||
field_defn_id | Field Definition Id | A Foreign Key to the Definition table. | bigint | |||
item_defn | Item Definition | true | true | The definition of an Item, which includes the Item Name and localizations and the collection of Item Fields. It also includes customizations and localizations of string resources for Item Names, and Item Field names. | ||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
item_table_name | Item Table Name | The name of the DBMS_Object_Name. It is a database object name, limited to 30 characters in length. | varchar(30) | |||
item_defn_id | Item Definition Id | A Foreign Key to the Definition table for an instance of type Definition. | bigint | |||
item_field_defn | Item Field Definition | true | true | Item Field Definition is an association between the Item Definition entity and the Field Definition entity. This association contains a distinct value for each of the intersection points between the two entities. | ||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
item_field_defn_id | Item Field Definition Id | A Foreign Key to the Definition table for an instance of type Definition. | bigint | |||
item_defn_id | Item Definition Id | A Foreign Key to the Definition table for an instance of type Definition. | bigint | |||
field_defn_id | Field Definition Id | A Foreign Key to the Definition table. | bigint | |||
tenant_parttn_defn | Tenant Partition Definition | true | true | The Root Node definition object that links to configuration settings and properties and the instance level, and also has the collection of Container Definitions below it. | ||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
db_schema_name | Database Schema Name | The name of the database schema. It is a database object name, limited to 30 characters in length. | varchar(30) | |||
defn_id | Definition Id | A Foreign Key to the Definition table. | bigint |