I will explain the problem with an example: I am designing a specific case of referential integrity in a table. In the logical design there are two tables,
document. We register the companies and then someone inserts the documents associated with it. The name of the enterprise is variable.
When it comes to recovering the documents, I need the name value of an enterprise to be the same as it was when it was registered and not the value it currently has.
The solution that I thought was to register the company again in each change with the same code, the updated name in this way would have the expected result, but I am not sure if it is the best solution. Can someone make a suggestion?