核心数据库表
2017-09-29 21:06:55 0 举报
哈哈哈,数据库设计,不要看啊不要看啊
作者其他创作
大纲/内容
inventory_right_in_rem1
id(bigint)channel_id(int)ware_house_id(bigint)bu_id(bigint)purchase_bill_no(varchar)allot_bill_no(varchar)return_bill_no(varchar)
N:1
inventory_right
id(bigint)channel_id(int)ware_house_id(bigint)related_id(bigint)related_type(int)inv_right_id(bigint)
inventory_flow
id(bigint)channel_id(int)ware_house_id(bigint)inv_detail_id(varchar)inv_outbound_id(varchar)origin_bill_no(varchar)spu_code(varchar)sku_code(int)amount(int)inventory_right_id(bigint)
inventory_detail_merged
id(bigint)channel_id(int)ware_house_id(bigint)inv_detail_ids(varchar)spu_code(varchar)sku_code(int)inbound(int)outbound(int)inv_right_id(bigint)
inventory_right_in_rem2
1:1
inventory_detail
id(bigint)channel_id(int)ware_house_id(bigint)inbound_bill_no(varchar)inbound_detail_id(varchar)spu_code(varchar)sku_code(int)batch_no(int)inbound(int)outbound(int)itype(int)inv_right_id(bigint)
inventory_outbound
id(bigint)channel_id(int)ware_house_id(bigint)outbound_bill_no(varchar)outbound_detail_id(varchar)spu_code(varchar)sku_code(int)batch_no(int)outbound(int)itype(int)inv_right_id(bigint)
outbound_goods_settlement
id(bigint)channel_id(int)ware_house_id(bigint)settle_type(int)outbound_bill_no(varchar)outbound_detail_id(bigint)spu_code(varchar)sku_code(int)outbound(int)bu_id(int)bu_name(varchar)origin_bill_no(varchar)inbound_batch_no(varchar)inbound_type(int)inbound_bill_no(varchar)
inventory_outbound_merged
id(bigint)channel_id(int)ware_house_id(bigint)inv_outbound_ids(varchar)spu_code(varchar)sku_code(int)outbound(int)inv_right_id(bigint)
inventory
id(bigint)channel_id(int)ware_house_id(bigint)spu_code(varchar)sku_code(int)inbound(int)outbound(int)
0 条评论
下一页