[kplato] Functional Breakdown (comments)

[bilbo]

On 19 Jun 2001, at 22:04, Jyry Kuukkanen wrote:

> 
> ("*" indicates a key)
> task {
>   *id int
>   description str
>   estimated_duration datetime
>   start_time datetime
>   done_time datetime
>   parent_task_no int
>   level int
>   phase int
>   status int
> }
> 
> dependencies {
>   *taskno int 
>   *dep_task_no int
> }

Or
task {
  *task_id int
  description str
  estimated_duration datetime
  contingency real
  contingency_type str
  planned_start_time datetime
  actual_start_time datetime
  planned_done_time datetime
  actual_done_time datetime
  parent_task_no int
  status int
  creator_userid int
}

and a necessary component both for audit and for formal change 
control:

taskchangehistory {
  *task_change_id int
  time_of_change datetime
  *task_id int
  *chenger_userid int
  old_value str
  new_value str
  value_name str
  change_reason str
  *changeid int
}

changerequest{
  *changeid int
  *requestor_userid int
  request_time datetime
}


regards,
        Bill