We have Opportunities and Accounts. Each Opportunity may have 1 or more Widget as part of that Opportunity. The Widgets are Dependent Child in the
LINK_OPPORTUNITY_ACCOUNT_SALES_ENGINEER. The Sales Engineer Assigned to the Opportunity may change during the course of the Opportunity
We need to track the Status of the Opportunity at the Widget Level. There is a date (
STATUS_DATE) associated with transition from one State to another. I am planning to hang a Satellite from the Link with:
STATUS_DATE as the PK for the SAT.
Is this in-line with the DV Standards?
What I am unsure about is that the LINK and the SATL will be at different grains.