title: How do you deal with Recursive Relationships N:M, in Database Relational Schema
body: <p>When we have a <strong>N:M Recursive Relationship</strong> what is the best way to create the <strong>relational schema</strong>? </p>
  
  <p>In various books I searched they analyze recursive relationships of 1:1 and 1:N but for N:M there is almost nothing.</p>
  
  <p>Should I treat it like a new Relationship like we do in traditional N:M non-recursive relationships?</p>
  
  <p>For example in this recursive relationship is it better to:</p>
  
  <p><strong><em>A.Create a new relationship</em></strong> </p>
  
  <p>INVITE(<strong>InviterId,InviteeId</strong>,AcceptanceDate,InvitationDate) - in bold the <strong>Primary Keys</strong> . In this case they are also foreign keys.</p>
  
  <p>////</p>
  
  <p><strong><em>B. Include this relationship in the Person Entity</em></strong></p>
  
  <p>PERSON(<strong>Id</strong>,Password,InviterId,InviteeId,AcceptanceDate,InvitationDate).</p>
  
  <p>///</p>
  
  <p><a href="https://i.stack.imgur.com/bQKzP.gif" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bQKzP.gif" alt="enter image description here"></a></p>