Re: model question

Philip Hallstrom
2009-11-12T19:30:39Z

> I am working on a apartments rent model.
>
> Some apartments are individual with address, price ... fields  and the
> model for this is streightforward.
> Some apartments are a collection of apts in a complex with the same
> address but different price, bedroom number ...
> What is a good way to structure this difference.
>
> I was thinking about adding to the Apartments model a "belongs to
> many"
> additional model. This child model would contain info on the
> apartments
> belonging to a multi unit complex.  But searching by price range
> sounds
> little messy in this case, with duplicate addresses resolving and
> combing through apartments and child complex model for pricing
>
> Any suggestions are very welcome

Perhaps have an Apartment model that is the complex.  Then have a Unit
model that has the details for that particular unit.  This creates a
little annoyance when you have an apartment complex that has only one
unit, but at least it''s consistent.

As for search by price range... add a "min_price" and
"max_price" to
the Apartment model and then some after save handlers on the Unit
model that would update those fields appropriately.  That way a search
by price is done only the the Apartment model and should be very
quick...

-philip