Subject Area : 050 - Item Relationship
Subject Area Name Definition
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.
ER Diagram Name Physical Display Level
Logical Column
Physical Column
Physical Name Entity/Table Name Logical Only Do Not Generate Definition
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.
Physical Name Attribute/Column Name Definition Physical Data Type
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
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_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.
Physical Name Attribute/Column Name Definition Physical Data Type
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
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.
Physical Name Attribute/Column Name Definition Physical Data Type
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)
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.
Physical Name Attribute/Column Name Definition Physical Data Type
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)