网上商城数据库类图

包含

创建

管理员Admin

+ id:varchar+ username:varchar+ password:varchar+ age:int+ create_time:date+ status:int

n

账单Bill

+ id:varchar+ amount:varchar+ order_id:varchar+ user_id:varchar

1

管理

查看

0

顾客Customer

+ name:varchar+ phone:varchar+ address:varchar+ status:int+ password:varchar

购物车Cart

+ id:varchar+ user_id:varchar+ product_id:varchar+ number:int

商品分类Category

+ id:String+ name:varchar+ sort:int+ image:varchar+ status:varchar

订单Orders

+ id:varchar+ ordertime:date+ phone:int+ address:varchar+ state:int+ total:Integer

商家Merchant

+ id:varchar+ username:varcahr+ phone:varchar+ role:varchar+ create_time:date+ status:int

m

购买

商品Product

+ name:varchar+ category_id:varchar+ is_hot:int+ image:varchar+ date:dayte+ market_price:int+ shop_price:int

发布