o2o-菜品数据库设计
2018-05-15 16:36:58 0 举报
菜品相关表设计图
作者其他创作
大纲/内容
warehouse_goods_sku_price_sales规格价格表
sku_price_sales_id:主键merchant_id:商户idgoods_order_type:订单类型sku_items_value:规格值warehouse_goods_id:仓库菜品idsales_price:售价sequence:序列create_time:创建时间update_time:更新时间version:版本
warehouse_goods_combo_group套餐组
goods_tastes_group_id=goods_tastes_group_id
warehouse_goods_tastes_item仓库菜品口味
warehouse_goods_tastes_item_id:仓库口味id goods_tastes_group_id:口味组id merchant_id:商户id goods_order_type:商口订单类型 warehouse_goods_id:仓库菜品id goods_tastes_unit_id:口味单元 sequence:序列 create_time:创建时间 update_time:更新时间 version:版本
warehouse_goods_id=ware_house_goods_id
id=goods_combo_group_id
goods_group菜品分组
goods_group_id:菜品分组idmerchant_id:商户idstore_id:门店idgroup_name:分组名称third_group_id:第三方组idsort_no:排序version:版本
store_goods_additional_group门店加值组
goods_additional_group_id:加值组idmerchant_id:商户idstore_id:门店idstore_goods_id:菜品idgoods_additional_name:加值名称goods_order_type:订单类型create_time:创建时间update_time:更新时间version:版本
goods_additional_itemId=goods_additional_id
goods_tastes_unit_id=goods_tastes_unit_id
warehouse_goods_sku_item仓库菜品规格
warehouse_goods_sku_item_id:主键goods_sku_group_id:规格组idmerchant_id:商户idgoods_order_type:订单类型warehouse_goods_id:仓库菜品idsku_unit_id:规格idsequence:序列create_time:创建时间update_time:更新时间version:版本
warehouse_goods_combo_group_item套餐组子项
store_goods_tastes_group门店菜品口味组
goods_tastes_group_id:口味组idmerchant_id:商户idstore_id:门店idstore_goods_id:菜品idtastes_group_name:口味组名称goods_order_type:订单类型tastes_group_sequence:序列create_time:创建时间update_time:更新时间version:版本
store_goodss_id=goods_id
store_goods_id=store_goods_id
warehouse_goods_sku_group仓库规格组
goods_sku_group_id:规格组idmerchant_id:商户idsku_group_name:规格组名称goods_order_type:订单类型sequence:序列warehouse_goods_id:仓库菜品idcreate_time:更新时间update_time:创建时间version:版本
goods_tastes_group_id= goods_tastes_group_id
goods_id=store_goods_id
group_goods菜品分组关联表
group_goods_id:主健merchant_id:商户idstore_id:门店idgoods_group_id:分组idstore_goods_id:菜品id
goods_additional_group_id=goods_additional_group_id
goods_id=store__goods_id
goods_additional门店菜品加值
goods_additional_id:加值idmerchant_id:商户idstore_id:门店idadditional_name:加值名称price:加值价stock_num:加值库存status:状态0:正常 -1:删除sold_num:销量create_time:创建时间update_time:更新时间
goods_sku_group_id=goods_sku_group_id
store_goods_additional_item门店菜品加值项
goods_additional_item_id:加值项idmerchant_id:商户idstore_id:门店idstore_goods_id:门店菜品idgoods_additional_group_id:加值组idgoods_order_type:订单类型goods_additional_id:加值idcreate_time:创建时间update_time:更新时间
warehouse_goods_tastes_group仓库菜品口味组
goods_tastes_group_id:仓库口味组id merchant_id:商户id tastes_group_name:口味组名称 goods_order_type:商口订单类型 warehouse_goods_id:仓库菜品id sequence:序列 create_time:创建时间 update_time:更新时间 version:版本
store_goods_combo_group门店套餐组
id:套餐分组idmerchant_id:商户idgroup_name:分组名称goods_order_type:订单类型goods_combo_id:套餐idavailable_count:可选数量sequnce:序列create_time:创建时间update_time:更新时间version:版本
store_goods_sku_group门店菜品规格组
goods_sku_group_id:规格组idmerchant_id:商户idstore_id:门店idstore_goods_id:菜品名称goods_order_type:订单类型sku_group_name:规格组名称sku_group_sequnce:序列create_time:创建时间update_time:更新时间version:版本
goods_id=goods_id
warehouse_goods_ext_picture仓库图文
goods_groip_id=goods_group_id
goods_tastes_unit菜品口味单元
goods_tastes_unit_id:口味项idmerchant_id:商户idtastes_name:门店idthird_tastes_id:第三访tastes_idstatus:口味状态create_time:创建时间update_time:更新时间version:版本
store_goods_combo_group_item门店套餐项
id:套餐idmerchant_id:商户idgoods_combo_id:套餐名称goods_combo_group_id:套餐组idgoods_id:菜品idgoods_sku_ids:规格组合available_count:可选数量sequnce:序列create_time:创建时间update_time:更新时间version:版本
store_goods门店菜品
ware_house_goods菜品仓库
ware_house_goods_id:仓库菜品idmerchat_id:商家idgoods_name:菜品名称recmd_in_price :推荐堂食价格pic_url:菜品图片地址is_allowd_price:是否允许重新定价status:状态total_sales:总销量version:版本goods_dtl:商品描述supp_order_typerecmd_out_price:推荐外卖价格bowl_fee:餐盒费total_out_sales:外卖销量total_in_price:总堂食销量is_tastes:是否有口味third_goods_idorigin_price:套餐中的原价type:菜品或套餐update_time:更新时间create_user:创建人update_user:更新人create_time:更新时间
store_goods_sku_item门店菜品规格项
store_goods_sku_item_id:规格项idgoods_sku_group_id:规格组idmerchant_id:商户idstore_id:门店idstore_goods_id:菜品名称goods_order_type:订单类型sku_unit_id:规格idsequnce:序列create_time:创建时间update_time:更新时间version:版本
store_goods_tastes_item门店菜品口味项
0 条评论
回复 删除
下一页