purchase_branch_product_batch

货品价格历史记录

所属应用: purchase

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
product_id	product_id	int(10) unsigned	Y		N
supplier_id	supplier_id	mediumint(8) unsigned	Y		N
eo_id	eo_id	mediumint(8) unsigned	Y		N
eo_bn	eo_bn	varchar(32)	Y		N
branch_id	branch_id	mediumint(8) unsigned	Y		N
purchase_price	purchase_price	decimal(20,3)	N		N
purchase_time	purchase_time	int(10) unsigned	N		N
store	store	mediumint(8) unsigned	N		N
in_num	in_num	mediumint(8) unsigned	N		N
out_num	out_num	mediumint(8) unsigned	N	0	N

索引

Key name	Column names	Unique	Comment
primary	product_id, supplier_id, eo_id	Y
idx_c_branch_id	branch_id	N