在线商城商品类图(关系图)
2018-04-09 18:07:25 1 举报
在线商城商品类图(关系图)
作者其他创作
大纲/内容
分类表(tb_Classfication)
+ id:type = integer+ name:type = varchar
+ operation1(params):returnType- operation2(params)- operation3()
生产日期
商品继承类的属性
商品(tb_Item)
+ id:type = integer+ name:type = varchar+ cla_id:type = integer+ seller_id:type = integer+ sales_volume:type = integer+ seller:type = varchar+ discription = longchar+ price: type = bigint+ score:type = bigint+ sku_num:type = integer+sku_sale_num = integer
1...n
属性名(tb_attribution_name)
+ id:type = int+ name:type = char+ classf_id:type = integer
商品和属性的关系表(tb_Item_Attribution)
+ id:type = int+ item_id:type = int+ att_name_id:type = int+ att_value_id:type = int
类固具有属性(如汽车牌子和颜色)
属性次父节点的子女节点
类(汽车)
商品是买卖交易的实体
属性值(tb_attribution_value)
+ id:type = int+ att_name_id:type = int
属性值
商品(奥迪Q10)
tb_Item
类的属性名(品牌,颜色)
0 条评论
下一页