hi all,
i come up these tables for my project and i'm looking for
advice/suggestion how to improve/optimize the structure further.
table item(itemid,warehouse,category,shapeid,....)
table shape(shapeid,physical_shape,...)
table dimension(dimensionid,itemid,shapeid,characteristic,...)
possible values for physical_shape:
round, hex, sheet, tubing, ... etc
possible values for characteristic:
diameter, length, width, height, ... etc
i have 2 questions:
1) can this be optimized any further?
2) i like to seperate itemid from dimension table, is it possible???
thanks,
t. hiep
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]