title: How to model party relationship data in ofbiz?
body: <p>I'm confused with the ofbiz data model.</p>
  
  <p><strong>PARTY RELATIONSHIP</strong> is a relationship from one <strong>PARTY</strong> to a another <strong>PARTY</strong> corresponding to a pair of <strong>PARTY ROLE</strong>s.</p>
  
  <p>Entity <strong>PARTY RELATIONSHIP</strong> will have <strong>PARTY_ID_FROM</strong>, <strong>PARTY_ID_TO</strong>, <strong>ROLE_TYPE_ID_FROM</strong>, <strong>ROLE_TYPE_ID_TO</strong> and <strong>PARTY_RELATIONSHIP_TYPE_ID</strong> which is stored in <strong>PARTY RELATIONSHIP TYPE</strong> entity.</p>
  
  <p>But in that entity is also stored <strong>ROLE_TYPE_ID_VALID_FROM</strong> and <strong>ROLE_TYPE_ID_VALID_TO</strong>.</p>
  
  <p>Could have duplicate data in there ?</p>
  
  <p>And would <strong>PARTY_RELATIONSHIP_TYPE_ID</strong> be a part of the key to the <strong>PARTY RELATIONSHIP</strong> entity?</p>
  
  <p><img src="https://i.stack.imgur.com/LvXZH.png" alt="Party relationship model"></p>