MYSQL Schema - Help
Posted: Fri May 22, 2009 2:32 pm
Hello, I am planning to code a site where will be similar to affiliate marketing website. For that I need to keep track of all their sales, I expect that my site will have 10,000 affiliates and over 500 different web products.
So, for that i wanted to know how to design a MYSQL Schema by which we can keep a record of all their sales organized with date, amount, commission, number of units sold, sold to whom etc..
How to do that?
Thanks in advance.
So, for that i wanted to know how to design a MYSQL Schema by which we can keep a record of all their sales organized with date, amount, commission, number of units sold, sold to whom etc..
How to do that?
Thanks in advance.