Database - Product Portfolio Relationship Table (product__portfolio)
Updated 8 months ago
Description
This table maps the relationship between products and portfolios. The primary key is a concatenation of the product_id and the portfolio_id.
Table Fields
Column | Data Type | Column Info | Value Notes |
product_id | INT(11) | The ID of the product associated with the portfolio. | |
portfolio_id | INT(11) | The ID of the portfolio associated with the product. | |
created | timestamp | A timestamp showing when the relationship was created, that is when the product was added to the portfolio. | |
lastUpdated | timestamp | A timestamp showing when this product portfolio relationship was last updated. | |
deleted | tinyint(4) | An integer value showing whether the portfolio relationship has been deleted. If the value is 1, this relationship will not be enforced. | 1 - Deleted 0 - Not Deleted |