EN
Español
English
Português
    ASDK_CATEGORY_FIELD

    Contains relationship information between a service category and an additional field

    Data model

    Fields

    Field Type Description
    category_id* INT Unique identifier of the service category, reference the table ASDK_CATEGORY.ctg_index
    field_id* INT Identifier of the additional field related to the category, reference the table ASMS_FIELDS.id
    service_id* INT Service identifier related to the category, reference the ASDK_SERVICE.id table
    type INT Identifies the behavior of the additional field for the category (1 = exclusive to the category, 2 = included)

    Primary Key

    PK_ASDK_CATEGORY_FIELD
    category_id, field_id, service_id

    References

    Column Referenced Table Referenced column Name
    category_id* dbo.ASDK_CATEGORY ctg_index F01_ASDK_CATEGORY_FIELD
    field_id* dbo.ASMS_FIELDS id F02_ASDK_CATEGORY_FIELD
    service_id* dbo.ASDK_SERVICE id F03_ASDK_CATEGORY_FIELD