EN
Español
English
Português
    APMO_WORK_ITEM_DEP

    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