I have been creating my custom page to include a rates page for products. I also have service that also have rates however some of the fields that are required on the product rates page are not used for the general service since a rate refers to a product and a service does not but a service does work on a per hour or flat rate depending on the service.
What would be the best way to go about creating an ecommerce table to handle all the rates of the different specifications that are chosen by a client and thereafter preserving the order details which would be saved in the database with the facility/product code, quantity, flat rates, and references intact...?
1) Should one table be used for the rates and one for order with its status OR
2) Should there be two tables (one for the service, one for the product rates) and then an order table with the items combined?
Let me know what you guys think is the best approach and why.