Postgresql – Modeling a relationship with SQL
I have the following in tables in PostgreSQL: Relationship: ID: int Status: string RelatedParty: RelationshipID: int PersonID: int Role: string The idea is that a relationship has two related parties, each of which has a role in the relationship. Only…