. система управления цепочками поставок для использования в клинике ASP.NET и SQL

My Name Is Dinesh Am Making A Website Supply Chain Management using Asp.net And Sql Server And I have no Idea about Database Design So Any One help me For Database design

Category	
Cat_id 	Int
Consumable	Varchar(100)
Retail	Int
Category_Name	Varchar(200)
Category_Type	Varchar(200)
Descriptions	Varchar(Max)
Active	Bit

Sub Category	
Sub_Cat_id	Int
Cat_id	Int
Sub_Cat_Name	Varchar(200)
Sub_Quantity	int
S_per_units_Price	Double
Size	int
UnitsInStoks	Bit
Selling_Price	Double
Actual_Price	Bigint
Discounts	Float
Units_weight	Float
Image	Varchar(200)
Active	bit

Item Master		
Pro_Code	Varcha(10)	PK
Pro_Name	Varcha(200)	
Category_Id	int	FK(category)
Sub_Category_ID	int	FK(Sub_category)
Barcode Number	Varcha(200)	
UMO	Varcha(200)	
Pro_Description	Varcha(200)	
Quantity	int	
Rate	float	
Foc	varchar(20)	
Vendor Code	Varcha(200)	
Units in each pack	varchar(20)	
UOM	varchar(20)	
Center Code (POS)	Int	

Vendor	Supliers
Vendor Code	Varchar(10)
Vendor Name	Varchar(200)
Vendor Address 1	Varchar(200)
Vendor Address 2	Varchar(200)
Vendor Address 3	Varchar(200)
Vendor City	Varchar(200)
Vendor State	Varchar(200)
Vendor Country	varchar(20)
Vendor Phone	varchar(20)
Vendor Contact	varchar(20)
Vendor Email	varchar(20)
DiscountType	varchar(20)
Corrent Order	Varcha(200)
Vendor Image	Varcha(200)
Customerid	Int

Center Master	Clinic
Center Code (POS)	
Center Code (SAP)	
Center Name	
Area	
Reason	
City	
State	
Country