may be my option wrong. if I do your project i will do this. * a project which has_many events * events which belongs_to :project event has_one sub_event
option II * a project which has_many events * events which belongs_to :project sub_event has column "sub_event_id". it just refer the sub_event table On Fri, Aug 20, 2010 at 12:57 AM, Sampath Munasinghe <[email protected] > wrote: > May be my > > > On Fri, Aug 20, 2010 at 12:52 AM, richardsugg <[email protected]>wrote: > >> I am implemented a simple project management application. Each >> project has various events, and each event can be a different type. >> Some event information is common, such as name, start date, close >> date, and comments. I have a projects table which has_many events. >> My plan is to have several sub-event tables, like event_get_access >> which will contain an event_id field to link it to table events as >> well as information specific to a "get access" event (remote access, >> username, passwords, etc). Another event type might be "upgrade" >> which stores information about the server to be upgraded, etc. >> >> So I have: >> * a project which has_many events >> * events which belongs_to :project >> * sub-events which belong_to :event >> >> How do the subevents relate to event? An event will never have more >> than one subevent, but it may not have any of a particular subevent. >> >> Thanks for your help on this? >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Ruby on Rails: Talk" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<rubyonrails-talk%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/rubyonrails-talk?hl=en. >> >> > -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
