Represents a relationship between open-state ICs
Data model
Fields
| Field | Type | Description |
|---|---|---|
| author_id | INT | Identifier of the user who created the relationship, references the table AFW_USERS.user_id |
| created_date | DATETIME | Date the relationship was created |
| fl_int_ci_child_id* | INT | Relationship child CI ID, reference table CMDB_CI.id |
| fl_int_ci_parent_id* | INT | Relationship parent CI ID, reference table CMDB_CI.id |
| fl_str_relationtype_id* | INT | Relationship type identifier, reference the ASMS_RELATION_TYPE.id table |
Primary Key
| PK_CMDB_CI_CI |
|---|
| fl_int_ci_parent_id, fl_int_ci_child_id, fl_str_relationtype_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| author_id | dbo.AFW_USERS | user_id | FK04_CMDB_CI_CI |
| fl_int_ci_child_id* | dbo.CMDB_CI | id | FK02_CMDB_CI_CI |
| fl_int_ci_parent_id* | dbo.CMDB_CI | id | FK01_CMDB_CI_CI |
| fl_str_relationtype_id* | Bod. ASMS_RELATION_TYPE | id | FK03_CMDB_CI_CI |