Describes a project
| Column | Type | References | Comments |
|---|---|---|---|
| id | Integer | Primary key | |
| code | String | A unique project code | |
| vdb_id | Integer | ||
| created | Date | Date this project was created | |
| team_id | Integer | db_group.id | ID of the group that corresponds to this team |
| project_category_id | Integer | db_project_category.id | ID of its project category |
| client_id | Integer | db_user.id | Client ID |
| manager_id | Integer | db_user.id | Project Manager ID |
| priority | Integer | Priority. 1 is for highest and 5 for lowest. | |
| summary | String | Short name of this project | |
| detail | String | Detail | |
| custom_form | String | Custom field values | |
| charging_model | Integer | ||
| ceiling_price | Float | ||
| start_price | Float | ||
| fixed_price | Float | ||
| fixed_cost | Float | Accumulated fixed cost for this project | |
| user_cost | Float | Accumulated user cost for this project | |
| budget | Float | Budget | |
| company_id | Integer | db_company.id | |
| folder_id | Integer | db_folder.id | ID of its document folder |
| forum_folder_id | Integer | db_folder.id | ID of its forum folder |
| archived | Date | Date when the project is in an 'end' phase | |
| archived_by_id | Integer | ID of the user who archived this project | |
| phase_id | Integer | db_project_phase.id | Phase of this project: 1 - In Progress, 2 - On Hold, 3 - Completed, 4 - Planning |
| plan_start | Date | Planned start date of this project | |
| plan_finish | Date | Planned finish date of this project. This will be the max of plan_finish of its tasks. | |
| deadline | Date | The deadline of this project | |
| percent_complete | Integer | % complete | |
| accumulated_cost | Float | Total accumulated cost | |
| b_expense_total | Float | Total billable expense | |
| nb_expense_total | Float | Total non-billable expense | |
| b_timesheet_total | Float | Total billable time sheet billing | |
| nb_timesheet_total | Float | Total non-billable time sheet billing | |
| estimated_work | Float | Total estimated work in minutes | |
| estimated_labor_cost | Float | Total estimated labour cost | |
| estimated_non_labor_cost | Float | Total estimated non-labour cost | |
| estimated_overheads | Float | Total estimated fixed cost | |
| expected_on | Date | Projected finish date | |
| b_timesheet_hours | Float | Billable time sheet hours | |
| nb_timesheet_hours | Float | Non-billable time sheet hours | |
| c_timesheet_hours | Float | Costable time sheet hours | |
| inherit_pc | Boolean (t or f) | Whether % complete is to be automatically calculated | |
| note_count | Integer | Total number of notes associated with its tasks | |
| message_count | Integer | Total number of email messages associated with its tasks | |
| phone_call_count | Integer | Total number of phone calls associated with its tasks | |
| status_update_count | Integer | Total number of task status updates associated with its tasks | |
| expense_count | Integer | Total number of expenses associated with its tasks | |
| time_entry_count | Integer | Total number of time entries associated with its tasks | |
| COMPUTED COLUMNS: | |||
| spi | Float | The schedule performance index using earned value method | |
| cpi | Float | The cost performance index using earned value method | |
| bcws | Float | The budgeted cost of work scheduled using earned value method | |
| bcwp | Float | The budgeted cost of work performed using earned value method | |
| acwp | Float | The actual cost of work performed using earned value method | |
| schedule_status | String | The schedule status. Will be one of: ON_TIME, AT_RISK, OVERDUE, BLOCKED, FUTURE and COMPLETED | |
| budget_status | String | The budget status. Will be one of: ON_BUDGET, AT_RISK, OVER_BUDGET | |
| client_root_name | String | The name of the client root in this project's client hierarchy | |
| client_name | String | The name of this project's client | |
| manager_name | String | The name of this project's manager | |