I'm having trouble determining the best setup for this database. It has, at the core, figures and products. a figure being a particular toy, a product being that figure in its box or multiple figures in a box. 

 

So I've got a figures tables and a product table and a "product contents" or product/figure association table. That all works fine. Where I get stumped is when there's different "levels" of products. For instance, one of the products we're trying to track is a box that contains up to 24 smaller boxes with figures in them. This Super Product contains multiple other products, but is basically just a box. like actual physical 4-sides-and-a-bottom made of cardboard box. It doesn't have its own UPC or licensing information, but does go through the whole process of design and color testing and such. 

 

My question is, should I make a new table for these super products, or should i attach the box to the products themselves and have a field to relate the products to each other when/if they show up in the same box? 

 

Any opinions would be appreciated. 

If your definition of 'product' is "figure in its box or multiple figures in a box", then "a box that contains up to 24 smaller boxes" does not fit your definition of 'product'.

 

What do you do with your products, and what part of your operation is this solution part of? Are "superproducts" treated the same as products in all the steps of your operations? Is there ever a need to make a distinction between 'products' and "superproducts"?