EN
Español
English
Português
    APMO_ITSM_RELATION

    Traceability relationships between core ITSM cases and module projects/work items (Origin, Linked, Converted, Blocks)

    Data model

    Fields

    Field Type Description
    is_active* BIT Logical Deletion: 1 = Active Record, 0 = Retired
    itsm_case_id* INT Related ITSM case (case INT ID in core; no physical KK)
    project_id UNIQUEIDENTIFIER Related project (optional)
    relation_id* UNIQUEIDENTIFIER Unique identifier of the relationship
    relation_type* VARCHAR (50) Relationship Type: Origin, Linked, Converted, or Blocks
    work_item_id UNIQUEIDENTIFIER Related work item (optional)

    Primary Key

    PK_APMO_ITSM_RELATION
    relation_id

    References

    Column Referenced Table Referenced column Name
    project_id dbo.APMO_PROJECT project_id FK01_APMO_ITSM_RELATION
    work_item_id dbo.APMO_WORK_ITEM work_item_id FK02_APMO_ITSM_RELATION