sky类图
2024-04-10 23:50:39 4 举报
试试
作者其他创作
大纲/内容
1:n
Setmeal(套餐)
Dish(菜品)
Employee(员工)
+ id:bigint+ name:varchar(32)+ username:varchar(32)+ password:varchar(64)+ phone:varchar(11)+ sex:varchar(2)+ id_number:varchar(18)+ status:int default 1+ create_time:datetime+ update_time:datetime+ create_user:bigint+ update_user:bigint
ShoppingCart(购物车)
+ add(添加购物车)+ delete(删除购物车)+ update(更新购物车)
Category(分类)
+ id:bigint+ type:int+ name:varchar(32)+ sort:int default 0+ status:int+ create_time:datetime+ update_time:datetime+ create_user:bigint+ update_user:bigint
1:1
address_book(地址)
+ id:bigint + user_id:bigint+ consignee:varchar(50)+ sex:varchar(2)+phone:varchar(11)+ province_code:varchar(12)+ province_name:varchar(32)+ city_code:varchar(12)+ city_name:varchar(32)+ district_code:varchar(12)+ district_name:varchar(32)+ detail:varchar(200)+ label:varchar(100)+ is_default:tinyint(1) default 0
+ add(添加地址)+ delete(删除地址)+ update(更新地址)+ match(查询当前用户地址基于user_id)
n:m
SetmealDish(套餐菜品关系)
OrderDetail(订单明细)
User(用户)
+ id:bigint+ openid:varchar(45)+ name:varchar(32)+ phone:varchar(11)+ sex:varchar(2)+ id_number:varchar(18)+ avatar:varchar(500)+ create_time:datetime
+ add(添加用户)+ delete(删除用户)+ update(更新用户)
Orders(订单)
DishFlavor(菜品口味)
+ id:bigint+ dish_id:bigint+ name:varchar(32) + value:varchar(255)
0 条评论
回复 删除
下一页