On 21 May 2010 15:49, [email protected] <[email protected]> wrote:
> Hello
>
> I have the three database models: "seller", "client" and "account". A
> seller may have many clients and many accounts, but I would like to
> add the constraint that given a seller and a client, only one account
> may exist between them.
>
> Is there a way to express this contraint using ActiveRecord relations?

Does Client belongs_to seller, and Account belongs_to seller?  If so
then you could put client and account together in one table.
Alternatively have Client has_one account and Account belongs_to
client, or the other way round.
This doesn't work if you have HABTM relationship of course.

Colin

-- 
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.

Reply via email to