VERIFIED SOLUTION i
How to understand the relationship between 'entity_history' and 'feature' in the Confirm Database
UPDATED: September 20, 2017
QuestionIs 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?
AnswerThere'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.
Product Feature: Ad-hoc Reporting
- No Downloads