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 |