EN
Español
English
Português
    ASDK_SERVICE_TYPE

    Represents the relationship between a Service Category and a Case type (Incident, Change, Problem, or Service Call)

    Data model

    Fields

    Field Type Description
    category_id INT Identifier of the associated category, reference the table ASDK_CATEGORY.ctg_index
    cost_model_id INT Identifier of the associated cost model, reference the table ASDK_MODEL_COST_PRICE.mod_id
    model_id INT Identifier of the associated model, reference the ASMS_MODEL.id table
    script_id INT Identifier of the associated script, reference the ASMS_SCRIPT.id table
    service_id* INT Associated service ID, reference the ASDK_SERVICE.id table
    type_id* INT Identifier of the associated case type, reference the ASMS_TYPES.id table

    Primary Key

    PK_ASDK_SERVICE_TYPE
    service_id, type_id

    References

    Column Referenced Table Referenced column Name
    cost_model_id dbo.ASDK_MODEL_COST_PRICE mod_id FK04_ASDK_SERVICE_TYPE
    model_id dbo.ASMS_MODEL id FK02_ASDK_SERVICE_TYPE
    script_id dbo.ASMS_SCRIPT id FK05_ASDK_SERVICE_TYPE
    service_id* dbo.ASDK_SERVICE id FK01_ASDK_SERVICE_TYPE
    type_id* dbo.ASMS_TYPES id FK03_ASDK_SERVICE_TYPE