Hire Equipment Pricing

Hi all, I’m working on a new project in which we’ll be hiring out camera equipment. On the product page there will be product page there will be a drop down menu where there will a list of days the lens can be hired out such as 7 days, 14 days, one month, etc. These timeframes remain the same on every product - however the pricing needs to be changeable for each period.

What would be the best way to implement this? Should I use a separate table or create a column for each hire period in my products table?

Any help or advice is appreciated as always! :slight_smile:

A separate table.
It will give you the flexibility to change/add/remove timeframes in the future, and even to differentiate them between products. I know you don’t want that now, but things change.

Hey dude, thanks for the quick reply. Yes, I think your right, that’s the best way forward. So should I have columns such as products_id, timeframe, price?

Sounds good

Cool, then I guess I would do a join on tables to integrate them together. Cool, thanks for your bud. Enjoy your morning/day! :slight_smile: