# Prices (where to store them and how)

**URL:** <https://www.ruby-forum.com/t/prices-where-to-store-them-and-how/128179>\
**Category:** Rails\
**Created:** [February 5, 2008, 5:24pm UTC](https://www.ruby-forum.com/t/prices-where-to-store-them-and-how/128179 "2008-02-05T17:24:55Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![bingobob](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/e480ec/32.png) [@bingobob](https://www.ruby-forum.com/u/bingobob)\
**Post date:** [February 5, 2008, 5:24pm UTC](https://www.ruby-forum.com/t/prices-where-to-store-them-and-how/128179/1 "2008-02-05T17:24:55Z")

</div>

trying to figure out the bet way to manage pricing in my app and  
basically the database design.

It’s a language school that also offers host family accomodation.

They therefore have

Courses which have to have the following prices

## fixed fees

exam fee  
reg fee

## recurring fees

price\_per\_week (1 to 2 weeks)  
price\_per\_week (3 to 4 weeks)  
price\_per\_week (5 to 6 weeks)

Accomodation has the following prices

## fixed fees

Accomodation Booking Fee

## recurring fees

price\_per\_week (single summer)  
price\_per\_week (shared summer)  
price\_per\_week (single winter  
price\_per\_week (shared winter)

I’m confused as to how to handle this, how many tables and what to call  
them?

Any help would be most welcome.