EN
Español
English
Português
    AVS_GROUP_SUPPORT_PERMISSION

    Table that stores support group permissions

    Data model

    Fields

    Field Type Description
    group_support_id* INT Unique identifier of the associated support group, reference to the table [AVS_GROUP_SUPPORT.id]
    group_user_id INT Unique identifier of the associated group, reference to the table [AFW_GROUPS.grou_id]
    id* INT Integer Type Primary Key
    user_id INT Unique identifier of the associated user, reference to the table [AFW_USERS.user_id]

    Primary Key

    PK01_AVS_GROUP_SUPPORT_PERMISSION
    id

    References

    Column Referenced Table Referenced column Name
    group_support_id* dbo.AVS_GROUP_SUPPORT id FK01_AVS_GROUP_SUPPORT_PERMISSION
    group_user_id dbo.AFW_GROUPS grou_id FK03_AVS_GROUP_SUPPORT_PERMISSION
    user_id dbo.AFW_USERS user_id FK02_AVS_GROUP_SUPPORT_PERMISSION