Baselined attributes for projects and tasks
Column | Type | References | Comments |
---|
id | Integer | | Primary key |
vdb_id | Integer | | |
baseline_number | Integer | | |
summaryname | 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 | | |
labourlabourlabor_cost | Float | | |
fixed_cost | Float | | |
project_budget | Float | | |
budget | Float |