EN
Español
English
Português
    CMDB_CI_CI_CLOSED

    It represents a relationship between ICs, where the parent IC is in a closed state

    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_DW_LAST.id
    fl_int_ci_parent_id* INT Relationship parent CI ID, reference table CMDB_CI_DW_LAST.id
    fl_str_relationtype_id* INT Relationship type identifier, reference the ASMS_RELATION_TYPE.id table

    Primary Key

    PK_CMDB_CI_CI_CLOSED
    fl_int_ci_parent_id, fl_int_ci_child_id, fl_str_relationtype_id