Entity whose possible types differ in the FK I have one entity called &quot;Groups&quot;.
&quot;Groups&quot; can be of different types and the difference between each type is the FK.
For instance, if a &quot;Group&quot; is of type &quot;Event Group&quot;, then it uses eventID; if it's of type &quot;Institution Group&quot;, then it uses institutionID.
What's the proper way to model this?
EventGroup would be one table, InstitutionGroup would be another, each with their own primary key and correlating fields. The foreign key in Group on eventID would reference the primary key in EventGroup, and the foreign key institutionID would reference the primary key in InstitutionGroup.