It represents a relationship between ICs
Data model
Fields
| Field | Type | Description |
|---|---|---|
| author_id | INT | Identifier of the user who created the relationship |
| author_name | NVARCHAR (510) | Name of the user who created the relationship |
| created_date* | DATETIME | Date the relationship was created |
| fl_int_ci_child_id* | INT | Identifier of the CI child of the relationship |
| fl_int_ci_parent_id* | INT | Identifier of the parent CI of the relationship |
| fl_str_relationtype_id* | INT | Relationship type identifier |
| relation_source_name | NVARCHAR (510) | Name of the parent-child relationship |
| relation_target_name | NVARCHAR (510) | Name of the child-to-parent relationship |
Primary Key
| PK_CMDB_CI_CI_DW |
|---|
| fl_int_ci_parent_id, fl_int_ci_child_id, fl_str_relationtype_id, created_date |