Help with database design needed
Could someone give me a hint about database design:
Say I have a database with products. I have names, prices, category, etc.
I want to add tech. specifications to my products. For every product there are at least 8-10 specifications and values.
name: Wide Leather Belt
weight: ?? kgs.
Is it better to keep them in the same table with the product, or separate?
There's plenty of sources around that'll make a better job explaining it than i ever will
If there is a different number of specs for each record, then you should definately put them in a seperate table.
Maybe the specs table could have the spec type as an enum, then the value as a varchar.
spProduct INT <- should relate to prNum
INDEX(spProduct ),PRIMARY KEY(spNum)
In a separate table... OK, thanks.