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)
|