Tweet
Hey everyone! I could use some help figuring something out. I've got a company database and I need to assign categories to each company. The structure is four levels deep: Industry Type → Group → Category → Subcategory.
Here's the tricky part: a single company can belong to multiple industry types, groups, categories, and subcategories at the same time. But there's also a hierarchy in place—not all combinations are valid. For example, certain groups only belong to specific industry types, certain categories only belong to certain groups, and so on.
I'm not sure how to implement this optimally. Any advice would be really appreciated!
Here's the tricky part: a single company can belong to multiple industry types, groups, categories, and subcategories at the same time. But there's also a hierarchy in place—not all combinations are valid. For example, certain groups only belong to specific industry types, certain categories only belong to certain groups, and so on.
I'm not sure how to implement this optimally. Any advice would be really appreciated!