Data model recommendations

[arwhyte]

Consolidation

You should be able to refactor the following four table relationships:

• country_area
• country_area_has_country
• country
• country_goal

down to:

• country_area
• country_goal (country_area_id, target_id, . . .)

There should be no countries in the MDG tables that are not in the UNSD country_area table.

Table names

Change the following:

• target_within_country_goal to target
• indicator_within_target to target_indicator

Property names

• Is the target value_type_id an FK for the indicator_id? If yes, then change value_type_id to indicator_id or is there a table missing? The country_goal.raw_value needs a raw_value_type defined somewhere.

[hopetambala]

I changed my model in accordance to this (i think) however before I load the CSV into the database, I wanted to make sure everything was right

https://github.com/hopetambala/django-sustainable_development_goals/tree/master/static/reference