Database - Product Sub-Portfolio Relationship Table (product__sub_portfolio)
This table maps the relationship between products and sub-portfolios. The primary key is a concatenation of the product_id and the sub_portfolio_id.
The ID of the product that is related to the sub-portfolio
The ID of the sub-portfolio assocated with the product.
A timestamp showing when the relationship was created, that is when the product was added to the sub-portfolio.
A timestamp showing when this product sub-portfolio relationship was last updated.
An integer value showing whether the sub-portfolio relationship has been deleted. If the value is 1, this relationship will not be enforced.
1 - Deleted
0 - Not Deleted