You should also track inventory of rooms and handle a range of dates (periods).
Other than that I like it :P On Nov 13, 10:15 am, Trausti Thor Johannsson <[email protected]> wrote: > Simple. > > Two tables. > > Rooms : > Has info like double bed, fridge, size and such. > > costs : <---- might need a better name > room_id > day > price > > Then you would say something like room has many costs > And then I would just use julian dates and you can easily ask each > room for dates in a given range. > > Trausti > > On Fri, Nov 13, 2009 at 6:28 AM, Greg <[email protected]> wrote: > > > Hi, I'm trying to make an app for a small hotel where I could load > > rooms into a database then assign a different nightly rate to them for > > each day in a calendar year. Each room would be loaded individually > > into the DB and and have it's own rate, you would then be able to > > search for a room by entering a date rang, the app would display all > > available rooms and the total nightly rate > > I'm not sure what the best practice to set this up would be. Does > > anyone know of an example app I could look at? > > > Thanks for your help - Greg. > > --~--~---------~--~----~------------~-------~--~----~ 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
