Footprints Data Model

Table
Table Name Item Relationship
Table Definition 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.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Item Relationship Id The automatically generated primary key of the item_reln table. LONG Yes
Item Relationship Definition Id A Foreign Key to the Definition table for an instance of type Definition. LONG No
From Item Definition Id A Foreign Key to the Definition table for an instance of type Item Definition. LONG Yes
To Item Definition Id A Foreign Key to the Definition table for an instance of type Item Definition. LONG Yes
From Item Id The From Item Id in the relationship. LONG Yes
To Item Id The To Item Id in the relationship. LONG Yes
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. LONG No