db_baseline
- Former user (Deleted)
- Rashmi Likhite
Owned by Former user (Deleted)
Baselined attributes for projects and tasks
| Column | Type | References | Comments |
|---|---|---|---|
| id | Integer | Â | Primary key |
| vdb_id | Integer | Â | Â |
| baseline_number | Integer | Â | Â |
| name | 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 | Â | Â |
| labor_cost | Float | Â | Â |
| non_labor_cost | Float | Â | Â |
| fixed_cost | Float | Â | Â |
| project_budget | Float | Â | Â |
| budget | Float |