__Orgs__
id
name
__Seasons__
id
org_id fk(orgs.id)
name
__Teams__
id
season_id fk(seasons.id)
name
__TeamFees__
id
team_id fk(teams.id)
*org_id<--- (?put extra fk here to avoid many joins?)
NO.
instead of it
use triggers before insert/update
CREATE FUNCTION foo() RE
Hi,
This is more of a general schema design, any advice is much
appreciated.
I have a Organization table. Nearly every other table in the schema
is related to this Org table in some way. So, some tables may be 3 or
4 tables 'away' from the Org table. In order to filter by the org_id,
I need to
