api_project_assignments
Description
The api_project_assignments table exposes project assignment entities, which represent the assignment of employees to
specific project services and item types.
Fields
| Field Name | Type | Description |
|---|---|---|
project_assignment_id | Integer | Unique identifier for the project assignment |
project_id | Integer | Identifier of the project |
project_service_id | Integer | Identifier of the project service |
project_item_type_id | Integer | Identifier of the project item type |
item_type_id | Integer | Identifier of the item type (hour type) |
employee_id | Integer | Identifier of the assigned employee |
assignment | String | Name or description of the assignment |
Related Tables
api_projects- Project details viaproject_idapi_project_services- Service details viaproject_service_idapi_employees- Employee details viaemployee_idapi_item_types- Item type details viaitem_type_idapi_project_assignments_facts- Daily facts viaproject_assignment_id