-2 down vote favorite


I want design the system the same as ResellerClub.com that users can have a personal panel and for each one who is a Reseller can create Resellers and make a Group and for each group have price and permission(ACL). A Client can buy products.

I designed these tables. Products can be submitted only by admin. Do you think this database is correct and optimized?

Users(id,fname,lname,group,parent_id,email,mobile, actived,date_created)
Payments(id,date,amount,method,auth_code,status,us er_id)
Configuration(id,email_notification,sms_notificati on,brand_name,brand_logo,roles,DNS_domain,user_id)
Groups(id,user_id,name,roles)
Prices(id,group_id,price,user_id)
Product_prices(id,group_id,product_id,price)
Product(id,name,price)