I was wrestling with creating a query for a report and came to the realization that there's an unsaid relationship between the project and releasetype tables. I was using a view of the database generated by SchemaSpy and these two tables appeared to be totally unrelated. Is there a foreign key relationship missing there?
In the release type table, there is a column called "refId". That is your project ID, but it is not a foreign key. Releases used to be at the organization level. We gave them the refId rather than introduce a new foreign key.
It seems that if there is a realtionship between the two tables that you'd want to have the DB engine help enforce the relationship so that you don't end up with orphan records, and also to make the relationship more concrete and obvious. Foreign key relationships aren't bad things.
