I'm looking to set up an ecommerce site for a client with around 1800 products in it. There will also be around 100 customers that receive different discounts on each of these products. unfortuanately this is not calculated as a percentage but rather each individual customer pays a different price for a pack of meat etc.
I'm really just looking for some advice on how to design the database.
I was thinking of making the following tables.
A product table containing the product ID, title description etc.
A price table with the product ID, customer Id, and then the price.
And also a customer table containing the customer Id, company name etc.
Is this a good way of doing it or can someone enlighten me as to a better way to do it.