Forum OpenACS Development: Schedule Package

Collapse
Posted by Tom Jackson on

Has anyone ever seen a schedule package? I have a fund raising project where I need to assign and track many tasks. If not, does anyone have an idea for a data model? I don't want to go overboard, but I drew up this as a guess (flames appreciated):


_skills_
 skill_id
 name
 description

_schedule_group_
 schedule_group_id
 name
 description

_tasks_
 task_id
 schedule_group_id
 skill_id
 description
 equipment
 material

_task_instance_
 instance_id
 task_id
 party_id
 location
 deadline
 time_estimate
 time_total
 pct_complete
  
_party_skill_map_
 party_id
 skill_id

There's got to be something better than this to start with.