EN
Español
English
Português
    AFLS_INVENTORY_SERVICE_PRODUCTS

    Table for recording the association of services with a particular product in the inventory.

    Data model

    Fields

    Field Type Description
    prod_id* INT Primary key of the table with product identifier.
    serv_id* INT Primary key of the table with service ID.
    srsp_quantity* INT Field where the quantity of products required for the service is expressed
    srsp_required* BIT Field where it is expressed whether registration is required or not

    Primary Key

    PK_AFLS_INVENTORY_SERVICE_PRODUCTS
    serv_id, prod_id

    References

    Column Referenced Table Referenced column Name
    prod_id* dbo.AFLS_INVENTORY_PRODUCTS prod_id FK02_AFLS_INVENTORY_SERVICE_PRODUCTS
    serv_id* dbo.AFLS_SERVICES serv_id FK01_AFLS_INVENTORY_SERVICE_PRODUCTS