EN
Español
English
Português
    AVS_DEVICE_GROUP_SUPPORT

    Table that stores the relationship of AVS devices and groups

    Data model

    Fields

    Field Type Description
    device_id* INT Unique device identifier related to the support group, reference to AVS_DEVICE.id table
    group_support_id* INT Unique identifier of the associated support group, reference to the AVS_GROUP_SUPPORT.id table
    id* INT Primary Key

    Primary Key

    PK01_AVS_DEVICE_GROUP_SUPPORT
    id

    References

    Column Referenced Table Referenced column Name
    device_id* dbo.AVS_DEVICE id FK01_AVS_DEVICE_GROUP_SUPPORT
    group_support_id* dbo.AVS_GROUP_SUPPORT id FK02_AVS_DEVICE_GROUP_SUPPORT