VERIFIED SOLUTION i

How to understand the relationship between 'entity_history' and 'feature' in the Confirm Database

Product Feature: Ad-hoc Reporting
 

Question

Is there a link between the table 'entity_history' and 'feature'? The schema does not show a link. If there is a link could you please provide the key field?
 

Answer

There's no actual link in the schema as the 'entity_history' table contains records for Features/Jobs/Defects etc.

There is a "soft" link which is that the history_entity_key column contains the Site Code and Plot Number of the Feature, separated by a slash.
UPDATED:  September 20, 2017