Sample Header Ad - 728x90

Historicizing of database models

3 votes
2 answers
416 views
We want to build a SQL-Database for a system to manage regulations in different countries for different years. The problem is that the regulations change every year for every country. Like for social insurance you need different data in 2015 than you needed in 2014 and we have companies that enter their data to connect with their social insurance informations for every year. If I want to build my models on this data I would have to create a different model for every year with different attributes. I can't just use migrations, because I have to keep the historical data and information. Right now I am researching for the right solution and I would like to know if there is a name for this problem to find some solutions?
Asked by herbertp. (89 rep)
Dec 6, 2016, 08:11 AM
Last activity: Jun 19, 2020, 07:00 PM