Advise on Data structure , Many Sub Categories
Posted on 2008-10-05
I've created a db, though i spent time on planning the structure,
i ended up with a lot and i mean A LOT, of progamming to do afterwords...
I want to redo the whole DB and could really use some advise.
This is a product Database:
Part No: PK123
Categories: Currently have 3 but will expand to more probably 1-2 per year
Type: anywhere from 3 to 12 types per categorie
Brand: a few hundred per categorie
Part No: already at 100,000 to 1 mil per category
Now what i did is crossed my findgers and hoped i could handle the programming afterwords:
Category (ID, Category)
Brand (ID, Brand, ....)
Part No ( ID , [Category ID] , [Brand ID], [Part No])
Description_Names ( ID, [Desc Name]) * lenght, meterial , Note , Etc..
Description (ID, [Part No ID] , [Desc Name ID], Value) * 20 cm, semi Metalic, etc..
In the description i stored everithing, Sizes, Material, etc...
My biggest problem is that every Type (not category) has its own description Fields,
some are same Unique and some are same, for example all have lenght , but only 2 Types have diameter.