购物商城 颜色、尺码交叉选择 设计方案求解答

[pjjmtylp2009]

最近项目上要做一个颜色和尺码的交叉选择 如图

随便看了下 其中包含如下代码 不太懂数据库如何设计 求高手解答

var PRODUCT_HASH=new Hash({ "1855":{ "bn":"20049598243-1", "price":388.11, "mktprice":0.00, "store":543, "weight":0.000, "mprice":{"1":388.10,"2":388.10,"3":388.10}, "spec_private_value_id":[ "658" , "670" ] } , 
							"1856":{ "bn":"20049598243-2", "price":388.12, "mktprice":0.00, "store":3334, "weight":0.000, "mprice":{"1":388.10,"2":388.10,"3":388.10}, "spec_private_value_id":[ "658" , "671" ] } , 
							"1857":{ "bn":"20049598243-3", "price":388.13, "mktprice":0.00, "store":214, "weight":0.000, "mprice":{"1":388.10,"2":388.10,"3":388.10}, "spec_private_value_id":[ "657" , "670" ] } , 
							"1858":{ "bn":"20049598243-4", "price":388.14, "mktprice":0.00, "store":443, "weight":0.000, "mprice":{"1":388.10,"2":388.10,"3":388.10}, "spec_private_value_id":[ "657" , "671" ] } }); 
							var SPEC_HASH=new Hash({ "657": { "product_id":[ "1857" , "1858" ], "images": [ ] } , 
													"658": { "product_id":[ "1855" , "1856" ], "images": [ ] } , 
													"670": { "product_id":[ "1855" , "1857" ], "images": [ ] } , 
													"671": { "product_id":[ "1856" , "1858" ], "images": [ ] } }); //计算货架商品会员价 window.addEvent('domready',function(){ if($E(".mktprice1")) { var xn_price = "388.10"; var mkPrice = parseFloat($E(".mktprice1").get("text").replace("￥","")); if(xn_price.length>0){ $E(".price1").set("text","￥"+xn_price) /*$E(".discount").set("text","优惠：" + ( (mkPrice-parseFloat(xn_price))/mkPrice * 100 ).toFixed(1) + "%");*/ } } }) 

[JavaNet的牛肉粉丝]

订单表：订单号，产品ID,尺码ID，颜色ID，数量 尺码表：尺码ID ,尺码名 颜色表：颜色ID，颜色名

[Andy__Huang]

这个问题好象在sql server版有人问过，不会是你的吧？问题还没解决吗

[pjjmtylp2009]

引用 2 楼 hdhai9451 的回复:

这个问题好象在sql server版有人问过，不会是你的吧？问题还没解决吗

不是我