CodingForums.com - View Single Post

Scrumpy.Gums · 06-08-2009, 09:53 PM

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.

06-08-2009, 09:53 PM	PM User \| #1
Scrumpy.Gums New Coder Join Date: Aug 2007 Posts: 14 Thanks: 3 Thanked 1 Time in 1 Post	Model relationships 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. __________________ "entia non sunt multiplicanda praeter necessitatem" - "Entities should not be multiplied beyond necessity" Occam's Razor