Footprints Data Model

Table
Name item_reln
Comment 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.

Column
Name Datatype Comment Is PK Is FK
item_reln_id bigint The automatically generated primary key of the item_reln table. Yes No
item_reln_defn_id bigint A Foreign Key to the Definition table for an instance of type Definition. No Yes
from_item_defn_id bigint A Foreign Key to the Definition table for an instance of type Item Definition. No Yes
to_item_defn_id bigint A Foreign Key to the Definition table for an instance of type Item Definition. No Yes
from_item_id bigint The From Item Id in the relationship. No Yes
to_item_id bigint The To Item Id in the relationship. No Yes
link_type_defn_ver_id bigint 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. No Yes