Associations Question

Rails
1

I have a three table construct. A “Users” table. Users have a one-to-
one relationship with a “Carts” table for saving the contents of a
shopping cart to the DB. I have a “Products” table for holding
product information. The Carts have a many-to-many relationship with
the Products. (One cart might have more than one product in it, and
one product might be represented in more than one user’s cart.)

What association would be best to describe this relationship? And
what would the migrations and model statements look like?

Thanks,

Andrew

2

2009/8/1 Andrew P. [email protected]:

Possibly:
User has_one Cart
Cart belongs_to User, has_and_belongs_to_many Products
Product has_and_belongs_to_many Carts

See the rails guides Getting Started and ActiveRecord Relationships at
http://guides.rubyonrails.org/ for more details.

Colin