Content Types with field "clusters". Possible or is there a different solution? My dilemma is this. At the moment I have a content type called "equipment" that I want to have a taxonomy term that will give a type of equipment, based on the selected type I want a new "cluster" of fields and/or taxonomy terms to pop up.

There is likely a different/better way of organizing the data.  Creating a new content type for each type of equipment doesn't seem very elegant, especially if I want to create a view for all of the equipment.

Any leads on where I can find a solution to this? My brain has problems with decorator patterns in SQL as well.
Probably the easiest solution is to have a single content type, add all fields that you need in any possible situation, and use Conditional Fields to hide/show fields based on the chosen equipment type taxonomy term.