EN
Español
English
Português
    ASMS_MODELPROFILES

    It contains information about the profiles that allow you to particularize assignments of specialists for different concepts such as cases, approvals, among others

    Data model

    Fields

    Field Type Description
    assign_specialist* BIT Assigning Profile Specialists
    description NVARCHAR (500) Profile Description
    id* INT Unique profile identifier
    model_id INT Identifier of the associated model, unique along with the name, type and project_id fields
    name NVARCHAR (100) Friendly, unique name along with the model_id, type, and project_id fields
    project_id INT Identifier of the associated project, unique along with the name, model_id and type fields
    type INT Associated entity type, unique along with the name, model_id, and project_id fields

    Primary Key

    PK_ASMS_MODELPROFILES
    id

    References

    Column Referenced Table Referenced column Name
    model_id dbo.ASMS_MODEL id FK01_ASMS_MODELPROFILES
    project_id dbo.ASMS_PROJECTS proj_id FK02_ASMS_MODELPROFILES
    type dbo.ASMS_TYPES id FK03_ASMS_MODELPROFILES