Given a relationship between two managed objects we might need additional metadata associated with that specific relationship. For example, For a given User with a Role such as Contractor, we might want a StartDate and an EndDate. This metadata is only relevant to that specific User->Role relationship.
The relationship and this metadata need to be stored in the managed repo and, ideally, in a way that can efficiently relate the two objects to the relationship for retrieval.
This task is also going to cover storing relationships as their own resource within the repository. We will likely be creating a ManagedObjectRelationship table and ManagedObjectRelationshipProperties.
Need to create managedobjectrelation table and have that addressable as a resource so we can performance CRUD operations in ManagedObjectSet. It has been agreed that the initial implementation will break MVCC guarantees and operate on this resource seperately from the base managed object.