EN
Español
English
Português
    ASMS_APPROVALS_PROFILES

    Contains the relationship between an approval and a profile

    Data model

    Fields

    Field Type Description
    approval_id INT Unique identifier of the approval, reference to the ASMS_APPROVALS.id table
    assing_specialist* BIT Determine if a profile specialist is assigned
    condition NVARCHAR (8000) Approval Condition and Profile
    id* INT Unique Approval and Profile Identifier
    profile_id INT Unique identifier of the profile, reference to the ASMS_MODELPROFILES.id table
    structure NVARCHAR (8000) Structure of the condition
    text_condition NVARCHAR (8000) Condition Text

    Primary Key

    PK_ASMS_APPROVALS_PROFILES
    id

    References

    Column Referenced Table Referenced column Name
    approval_id dbo.ASMS_APPROVALS id FK01_ASMS_APPROVALS_PROFILES
    profile_id dbo.ASMS_MODELPROFILES id FK02_ASMS_APPROVALS_PROFILES