核心数据库表

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)