One Requirement has a one to many relationship with product. i.e. There could be more than one product for a given requirement.
If it is straightforward to add to add a Product Group (products rollup to a product group) then that would be great as well.
Data elements:
product:
product_id - int(11) auto number
product_name - VARCHAR(255)
product_description - VARCHAR(255)
requirement_product:
product_id - int(11)
requirement_id - int(11)
product_group:
product_group_id - int(11) auto number
product_group_name - VARCHAR(255)
product_group_description - VARCHAR(255)
product_product_group:
product_id - int(11)
product_group_id - int(11)
Would need 2 tabs to be able to add product and product group master data. As well as modify the requirements screens to show the product and product groups related to each.
Nathan Edmundson
Slav, this had not been assigned so I put it to you to review. If you would like someone else to review it please let me know.
Thanks,
Nathan
what do you think?
@waa: Is ok for me, if ok for you too please forward it to slav for implementation.
Is also ok for me