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. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---