hi all,
after a little 'research' and consultation with friends, i come up with
these tables for my database project.
table Item(ItemID,warehouse,ShapeID,weight,category,description)
table Shape(ShapeID,physical shape)
table Dimension(DimensionID,dimension)
table ShapeDimension(ShapeDimensionID,ShapeID,DimensionID)
table ItemShapeDimension(ItemID,ShapeDimensionID,value)
ItemID,ShapeID,DimensionID, and ShapeDimensionID are primary keys, auto
increment
Shape & Dimension are static tables
Shape: Round, Hex, Angle, Channel, Pipe,..etc.
Dimension: Diameter, Length, Width, Depth, Inner Diameter, Outer
Diameter...etc.
do you have any comment for this??? is there any potential structure
problem with these relationship?
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
