Subject Area : 050 - Item Relationship
Subject Area(s) of Model "Renoir Domain Model Detail"
# Name Definition ER Diagram Entity/Table
Total
. 050 - Item Relationship A generic table that stores a relationship between two dynamic items. Since the dynamic items might be in different containers, all relationships are stored in a single generic table. Partitioned indexes might be designed on this table if performance becomes a problem, using one or both definition ids as partition keys. Details.. Details..
ER Diagram(s) of Subject Area "050 - Item Relationship"
# Name Physical Display Level
Total 2
. Logical Column
. Physical Column
Entity/Table(s) of Subject Area "050 - Item Relationship"
# Physical Name Name Logical Only Do Not Generate Definition Attribute/Column
Total 5
. 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_reln Item Relationship false An Item Relationship is a relationship between instances contained in two Dynamic Object generated Tables. For example, the following. A Configuration Item Type ("Computer") related to an Workspace Item ("Incident"). An Address Book Entry ("Contact") related to another Address Book Entry ("Master Contact"). A Dynamic Link between an Incident in Workspace 1 ("Current Tickets") and Workspace 3 ("Archive Workspace").
A Dynamic Link between an Incident in Workspace 1 ("Current Tickets") and Workspace 5 ("Change Management"). There are no foreign keys defined.
Details..
. item_reln_defn Item Relationship Definition true true The definition of a Relationship type within the Container Definition. This has important Configuration_Settings and Application Element Identifier values that clarify the meaning of the Relationship to programming code. Details..
. link_type_defn_ver Link Type Definition Version true true A definition version instance that describes the link properties. This design allows the link properties to be dynamically defined by configuration settings. That way links can add behavior in the future without affecting existing data. Details..
Attribute/Column(s) of Entity/Table "Item"
# Physical Name Name Definition Physical Data Type
Total 4
. item_key Item Key A search key for the Item, composed of letters and numbers. varchar(255)
. item_id Item Id The automatically generated primary key of the item table. bigint
. cntnr_id Container Id A Foreign Key to the Container table. bigint
. item_defn_id Item Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
Attribute/Column(s) of Entity/Table "Item Definition"
# Physical Name Name Definition Physical Data Type
Total 2
. item_table_name Item Table Name The name of the DBMS_Object_Name. It is a database object name, limited to 30 characters in length. varchar(30)
. item_defn_id Item Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
Attribute/Column(s) of Entity/Table "Item Relationship"
# Physical Name Name Definition Physical Data Type
Total 7
. item_reln_id Item Relationship Id The automatically generated primary key of the item_reln table. bigint
. item_reln_defn_id Item Relationship Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
. from_item_defn_id From Item Definition Id A Foreign Key to the Definition table for an instance of type Item Definition. bigint
. to_item_defn_id To Item Definition Id A Foreign Key to the Definition table for an instance of type Item Definition. bigint
. link_type_defn_ver_id Link Type Definition Version Id A Foreign Key to the Definition Version table for an instance of type Link Type Definition Version. The link type will hold the configurable properties for the relationship. bigint
. from_item_id From Item Id The From Item Id in the relationship. bigint
. to_item_id To Item Id The To Item Id in the relationship. bigint
Attribute/Column(s) of Entity/Table "Item Relationship Definition"
# Physical Name Name Definition Physical Data Type
Total 4
. item_reln_defn_id Item Relationship Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
. from_mbr_role_type_id From Member Role Type Id char(18)
. to_mbr_role_type_id To Member Role Type Id char(18)
. reln_type_id Relationship Type Id Relationship type char(18)
Attribute/Column(s) of Entity/Table "Link Type Definition Version"
# Physical Name Name Definition Physical Data Type
Total 9
. link_type_defn_ver_id Link Type Definition Version Id The automatically generated primary key of the Definition Version table for a an instance of type link_type_defn_ver. bigint
. cardinality_node_2 Cardinality Node 2 The value of a Cardinality Node 2 stored as a Configuration Setting owned by the Link Type Definition Version. See the meta data stored in the Configuration Setting table where dflt_setting_label = 'Cardinality Node 2'. char(18)
. color_val_setting Color Value Setting The value of a Color Value Setting stored as a Configuration Setting owned by the Link Type Definition Version. See the meta data stored in the Configuration Setting table where dflt_setting_label = 'Color Value Setting'. char(18)
. item_type_node_1 Item type Node 1 The value of a Item type Node 1 stored as a Configuration Setting owned by the Link Type Definition Version. See the meta data stored in the Configuration Setting table where dflt_setting_label = 'Item type Node 1'. char(18)
. cardinality_node_1 Cardinality Node 1 The value of a Cardinality Node 1 stored as a Configuration Setting owned by the Link Type Definition Version. See the meta data stored in the Configuration Setting table where dflt_setting_label = 'Cardinality Node 1'. char(18)
. item_type_node_2 Item type Node 2 The value of a Item type Node 2 stored as a Configuration Setting owned by the Link Type Definition Version. See the meta data stored in the Configuration Setting table where dflt_setting_label = 'Item type Node 2'. char(18)
. node_1_name Node 1 Name The value of a Node 1 Name stored as a Configuration Setting owned by the Link Type Definition Version. See the meta data stored in the Configuration Setting table where dflt_setting_label = 'Node 1 Name'. char(18)
. node_2_name Node 2 Name The value of a Node 2 Name stored as a Configuration Setting owned by the Link Type Definition Version. See the meta data stored in the Configuration Setting table where dflt_setting_label = 'Node 2 Name'. char(18)
. symmetric_link Symmetric Link The value of a Symmetric Link stored as a Configuration Setting owned by the Link Type Definition Version. See the meta data stored in the Configuration Setting table where dflt_setting_label = 'Symmetric Link'. char(18)