A relationship object describes the affiliation between two specific entities.
A relationship object can be one of the following object:
Relationship Base Object
Maintains a relationship between two entity base objects. Use relationship base objects to establish a many-to-many relationship.
Foreign Key Base Object
A foreign key base object is an entity base object with a foreign key column. Use foreign key base objects to establish a 1-to-1 or 1-to-many relationship. For example, many products might relate to a single product group. An entity base object can have more than one foreign key column. Each foreign key column maintains a relationship.
Hierarchy relationships are defined by specifying the relationship type, hierarchy type, attributes of the relationship, and dates for when the relationship is active.
The Relationship node in the Schema tool display hierarchy relationships and data model relationships.