...
| Column | Type | References | Comments |
|---|---|---|---|
| id | IntegerInteger | Primary Primary key | |
| vdb_id | IntegerInteger | ||
| baseline_number | IntegerInteger | ||
| summary | StringString | A A small summary | |
| creator_id | IntegerInteger | ||
| created | DateDate | ||
| project_id | IntegerInteger | db_project.id | When When not-null and task and resource ids are null, means this is for the project level |
| task_id | IntegerInteger | db_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_budget | FloatFloat | ||
| budget | Float | Float |