material_basic_material_stock_freeze

基础物料预占流水表

所属应用: material

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
bmsf_id	bmsf_id	int(10) unsigned	Y		Y
bmsq_id	配额ID	int(11)	N		N
bm_id	基础物料ID	int(10) unsigned	N		N
sm_id	销售物料ID	int(10) unsigned	N		N
obj_id	对象ID	int(10) unsigned	N	0	N
obj_bn	对象编号	varchar(255)	N		N
obj_type	对象类型	tinyint(1)	N		N
bill_type	业务类型	tinyint(1)	N	0	N
sub_bill_type	业务子类型	varchar(255)	N		N
shop_id	店铺ID	varchar(32)	N		N
branch_id	仓库ID	mediumint(8) unsigned	N	0	N
num	冻结数	mediumint(8) unsigned	N	0	N
create_time	创建时间	int(10) unsigned	N		N
last_modified	最后更新时间	int(10) unsigned	N		N
store_code	预选仓库编码	varchar(64)	N		N
original_item_id	原单明细行ID	int(10) unsigned	N	0	N
source	调用来源方法	varchar(255)	N		N
at_time	创建时间	TIMESTAMP	N	CURRENT_TIMESTAMP	N
up_time	更新时间	TIMESTAMP	N	CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP	N

索引

Key name	Column names	Unique	Comment
primary	bmsf_id	Y
ind_obj_type_id	obj_id, obj_type	N
ind_bm_obj_shop	bm_id, obj_type, shop_id	N
ind_obj_bn	obj_bn	N
ind_objtype_smid	obj_type, sm_id	N
idx_bmid_num	bm_id, num	N
ind_branch_obj_bill_bm	branch_id, obj_type, bill_type, bm_id	N
ind_attime	at_time	N
ind_uptime	up_time	N
ind_num	num	N