Topic: Setting Up Table/s Question
I'm creating my first rails site and since I'm pretty new to dynamic sites need some advice on setting up the table.
Basically the client has products and I am going to put them into a product model and products table.
However these products can be both sold or hired so there will be a hiring page and a products for sale page, and a specials page on the site.
Information for the products involves the following details
if the product is for sale then the following information is required also
Recommended retail price
If product is a pair then pair sale price
if product is a single item then single item price
If the product is on special/discounted
recommended retail price
if product is for hire then the following information is required also
What I'm not sure about is should I have separate tables being
and have a relationship between the tables? If so any suggestions on where to start to do this. I know how to create a model, table, controller but I haven't done any work with multiple tables.