VERIFIED SOLUTION i
X

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

UPDATED: September 20, 2017


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.

Environment Details

Product Feature: Ad-hoc Reporting
 

Downloads

  • No Downloads