I am creating a database to hold all the data for a customer portal for a business.
The portal will hold all information about the orders that customers place and the status of the orders.
The business offer different prices to each customer for the products and this has created a bit of a problem in terms of my design for the database.
My current ideas are as follows:
Orders Table (details of each order including the total price for the order)
OrderItems Table (details of what items are included in the order)
Products Table (containing all the details of each product they sell excluding the price of each item)
I now need somewhere to store each customer's price list and still have a link to the Products table.
Does anyone have any thoughts as to how I may achieve this?