...

Model relationships

Scrumpy.Gums
06-08-2009, 09:53 PM
I have two DB tables: Themes and Events with the following relevant columns:

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

oesxyl
06-09-2009, 01:16 AM
I have two DB tables: Themes and Events with the following relevant columns:

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

Scrumpy.Gums
06-09-2009, 02:02 PM
One theme has many events. Events have only one theme, so one-to-many :)



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum