Discounty_category (master)
Id - int
Name -nvarchar(150)
is_active - bit
Is_deleted - bit
Created_date - datetime
Modify_date - datetime nullable
Created_by - int 
Modified_by - int nullable

Mster Values of this table
First Order(20%)
Prime customers get an extra 5% off their order	
Buy One Get One free
Free Shiping
Redeem reward points
Refer a friend and get $40 in your rewards

Discount_subcategory
Id - int
name -nvarchar(150)
Parent_category_id int
is_active - bit
Is_deleted - bit
Created_date - datetime
Modify_date - datetime nullable
Created_by - int 
Modified_by - int nullable

tbl_product_discount
Id - int
Sub_category_id int 
percent decimal
Fixed decimal
Coupe n_code	nvarchar(50)
Expiry datetime
min_order_value decimal 
max_discount_amt decimal
is_redeem_allowed bit
Created_date - datetime
Modify_date - datetime nullable
Created_by - int 
Modified_by - int nullable