类似于这个网站的"菜单选项"
http://waimaimall.com/search/shop/0-0-0-0-0-1-1-%E9%A6%99%E6%B8%AF%E8%B7%AF125%E5%8F%B7-DGDJTHTHZJBRJWHT-3
http://waimaimall.com/search/shop/0-0-0-0-0-1-1-%E9%A6%99%E6%B8%AF%E8%B7%AF125%E5%8F%B7-DGDJTHTHZJBRJWHT-3
建一个商品表 products(product_id, product_name, ...)product_id为主键
再建一个店铺-商品表 store_product(store_id, product_id, price,...)store_id为外键,product_id为外键,唯一约束unique(store_id, product_id)