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?