api_project_service_hour_budgets
Description
The api_project_service_hour_budgets table exposes hour budget information configured for project services, broken
down by item type.
Fields
| Field Name | Type | Description |
|---|---|---|
project_id | Integer | Identifier of the project (composite key) |
project_service_id | Integer | Identifier of the project service (composite key) |
item_type_id | Integer | Identifier of the item type (hour type) (composite key) |
budget_hours | Numeric | Total budgeted hours for this service and item type |
budget_value | Numeric | Total budgeted monetary value for this service and item type |
Related Tables
api_projects- Project details viaproject_idapi_project_services- Service details viaproject_service_idapi_item_types- Item type details viaitem_type_id