Baselined attributes for projects and tasks
| Column | Type | References | Comments |
|---|---|---|---|
| id | Integer | Primary key | |
| vdb_id | Integer | ||
| baseline_number | Integer | ||
| summary | String | A small summary | |
| creator_id | Integer | ||
| created | Date | ||
| project_id | Integer | db_project.id | When not-null and task and resource ids are null, means this is for the project level |
| task_id | Integer | db_task.id | When not-null and resource id id nul, means this is for the task level |
| resource_id | Integer | When not-null means this is for the assignment level | |
| start_date | Date | Plan start date | |
| finish_date | Date | Plan finish date | |
| project_start | Date | Project start date | |
| project_deadline | Date | Project finish date | |
| duration_value | Float | ||
| duration_type | Integer | ||
| effort | Float | ||
| labour_cost | Float | ||
| non_labour_cost | Float | ||
| fixed_cost | Float | ||
| project_budget | Float | ||
| budget | Float |