虚拟仓库存锁定

stock_allocate_rule_member(库存分配规则成员)

id  bigintrule_id  biginttype  tinyint 1-店铺，2-分销商member_id bigintcreated datetime

parent_item_id

virtual_warehouse_op_log(虚拟仓操作日志)

parent_detail_id

rule_id

user

virtual_warehouse_id

virtual_warehouse_item(虚拟仓商品)

id  intvirtual_warehouse_id  intlock_type  tinyint 1-临时活动，2-日常运营lock_target tinyint 1-链接，2-系统商品lock_status tinyint 0-锁定中，1-已解锁sys_item_id bigintsys_sku_id bigintuser_id bigintnum_iid varchar(64)sku_id varchar(128)item_type tinyint 1-普通商品，2-套件lock_count inttrade_used_count intend_time datetimeend_auto_release tinyint 0-false 1-trueremark varchar(128)creator_name  varchar(64)created datetimemodifier_name varchar(64)modified datetime

virtual_warehouse_sub_item_lock_count_detail(虚拟仓子商品锁定数明细)

id  bigintparent_detail_id bigintouter_id varchar(255)sku_outer_id varchar(255)change_num intcreated datetime

member_id

item_id

sid

virtual_warehouse_item_lock_count_detail(虚拟仓商品锁定数明细)

id  bigintitem_id bigintchange_num intafter_change_count intchange_type tinyint 1-添加锁定，2-调整锁定数，3-解锁creator_name  varchar(64)created datetime

virtual_warehouse_sub_item(虚拟仓子商品)

id  bigintparent_item_id bigintsys_item_id  bigintsys_sku_id  bigintlock_count inttrade_used_count intcreator_name  varchar(64)created datetimemodifier_name varchar(64)modified datetime

virtual_warehouse_trade_used_record(虚拟仓订单使用记录)

id  bigintitem_id bigintsid  bigintused_count  inttrade_created datetimetrade_pay_time datetimeshop_title varchar(128)created datetimemodified datetime

stock_allocate_rule_item(库存分配规则商品)

id  intrule_id  intsys_item_id bigintsys_sku_id bigintuser_id bigintnum_iid varchar(64)sku_id varchar(128)item_type tinyint 1-普通商品，2-套件created datetime

trade

stock_allocate_rule(库存分配规则)

id  bigintname varchar(64)warehouse_id bigintpriority intstart_time datetimeend_time datetimechange_num intcreated datetimemodified datetime

customer

virtual_warehouse(虚拟仓)

id  bigintname  varchar(64)warehouse_id bigintstatus  tinyint 1-正常creator_name  varchar(64)created datetimemodifier_name varchar(64)modified datetime

virtual_warehouse_member(虚拟仓成员)

id  bigintvirtual_warehouse_id  biginttype  tinyint 1-店铺，2-分销商member_id bigintcreated datetime