Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Baselined attributes for projects and tasks

 Float Float
ColumnTypeReferencesComments
id IntegerInteger  Primary Primary key
vdb_id IntegerInteger  
baseline_number IntegerInteger  
summary StringString  A A small summary
creator_id IntegerInteger  
created DateDate  
project_id IntegerIntegerdb_project.id When When not-null and task and resource ids are null, means this is for the project level
task_id IntegerIntegerdb_task.id When When not-null and resource id id nul, means this is for the task level
resource_id IntegerInteger  When When not-null means this is for the assignment level
start_date DateDate  Plan Plan start date
finish_date DateDate  Plan Plan finish date
project_start DateDate  Project Project start date
project_deadline DateDate  Project Project finish date
duration_value FloatFloat  
duration_type IntegerInteger  
effort FloatFloat  
labour_cost FloatFloat  
non_labour_cost FloatFloat  
fixed_cost FloatFloat  
project_budgetFloat  
budgetFloat