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