Rails model that joins through a join table

Question

Is this possible?

In an events system an event can have multiple times. (ie, if it is a 3 day event and each day it's at a different time). Each time has a place associated with it. Finally, each place has an address associated with it. Now, can I reference those addresses through my event model?

I'm thinking something conceptually like this:

class Event < ActiveRecord::Base
    has_many :TimePlaces
    has_many :Places :through => :TimePlaces
    has_many :Addresses :through => :PlaceAddresses :through => :Places

Answer 1

This is the right syntax.

class Event < ActiveRecord::Base
    has_many :time_places
    has_many :places, :through => :time_places
    has_many :addresses, :through => :places

Despite this should work, you might want to redesign your database. Running a query with too many joins requires an intensive database elaboration and drastically slows down your application.

Answer 2

also keep in mind convention is to be alphabetical within the join table syntax therefore it should be has_many :places, :through => :place_times