EN
Español
English
Português
    ASDK_ITEM_IDS

    Contains the consecutive of the projects according to the type of case

    Data model

    Fields

    Field Type Description
    item_id INT Related case ID, reference table ASDK_ITEM.id
    item_type_id* INT Identifier of the type of record (Incident, Change, Problem, Requirement, Request, among others), reference the ASMS_TYPES.id table
    project_id* INT Associated project ID, reference table ASMS_PROJECTS.proj_id

    Primary Key

    PK_ASDK_ITEM_IDS
    project_id, item_type_id