I'd also expect organization table to just have a parentOrgId as foreign key, not need some ParentOrg separate table as its a one to one optional to list a parent org that allows for building hierarchy...