Database - Product Sub-Portfolio Relationship Table (product__sub_portfolio)
Updated 8 months ago
Description
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.
Table Fields
Column | Data Type | Column Info | Value Notes |
product_id | INT(11) | The ID of the product that is related to the sub-portfolio | |
sub_portfolio_id | INT(11) | The ID of the sub-portfolio assocated with the product. | |
created | timestamp | A timestamp showing when the relationship was created, that is when the product was added to the sub-portfolio. | |
lastUpdated | timestamp | A timestamp showing when this product sub-portfolio relationship was last updated. | |
deleted | tinyint(4) | 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 |