I am new in this forum. Excuse me for my English, but I am learning and for me is very difficult to write in English.
As you are supposing I need help in the designing of some tables, perhaps a little orientation. I am working in a project about a group of cities, and development indicators (???) like unemployment rate and salary rate (150 indicators in total) .
There are 5 indicator types, and 30 subtypes (more or less). To calculate these indicators I have in total 220 variables, and the indicators must be calculated every year.
I need all indicators calculated in a table, because it is going to be used in a map service to create thematic maps, and it cant be calculated when the users display the map.
This has been my solution:
There are 220 variable types
[Id,Name,Explanation] today 5 registers
[Id,TypeId,Name,Explanation] today 150 registers
[subTypeId, CityId, Value,Year]
My idea is that when someone put a new value or changes a value in Variables, calculate all indicators calculated with this variable with triggers.
What do you think about my solution? Is it a good idea?