I'm building a database model that requires one table to have a relationship to only one of several other tables. For example, a
Contract may be associated with a
Business, or a
Government, but only one of those.
Other than having a foreign key column for each of those and using a check constrain to ensure only one is populated, what is the best approach to this situation?