View Single Post
Old 06-09-2009, 01:16 AM   PM User | #2
oesxyl
Master Coder


 
Join Date: Dec 2007
Posts: 6,682
Thanks: 436
Thanked 890 Times in 879 Posts
oesxyl is a jewel in the roughoesxyl is a jewel in the roughoesxyl is a jewel in the rough
Quote:
Originally Posted by Scrumpy.Gums View Post
I have two DB tables: Themes and Events with the following relevant columns:
Code:
Theme:
integer month

Event:
datetime date_begin
So each theme has many events and they are linked through Event date_begin month and Theme month. My question is how to represent this in the models. I've tried the following and many variations in the Theme model but they don't work.
Code:
has_many :events, :through => :events_date_begin.month
I could store the month separately in the Event table but then it's redundant. Are there any better alternatives?

Thanks in advance.
theme and events is a one-to-many or many-to-many relation?

best regards
oesxyl is offline   Reply With Quote