Dependencies between work items (source - destination) for Gantt and planning
Data model
Fields
| Field | Type | Description |
|---|---|---|
| dependency_id* | UNIQUEIDENTIFIER | Unique identifier of the dependency |
| dependency_type* | VARCHAR (50) | Dependency type (e.g. FinishToStart, Blocks) |
| description | NVARCHAR (MAX) | Description of the dependency |
| is_active* | BIT | Logical Deletion: 1 = Active Record, 0 = Retired |
| source_work_item_id* | UNIQUEIDENTIFIER | Work item dependency source |
| target_work_item_id* | UNIQUEIDENTIFIER | Work item dependency target |
Primary Key
| PK_APMO_WORK_ITEM_DEP |
|---|
| dependency_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| source_work_item_id* | dbo.APMO_WORK_ITEM | work_item_id | FK01_APMO_WORK_ITEM_DEP |
| target_work_item_id* | dbo.APMO_WORK_ITEM | work_item_id | FK02_APMO_WORK_ITEM_DEP |