Data integrity (similar to relational DB)

[nghugo]

• Ensure only existing plans can be input when adding/modifying the plan field of camps (if no plans, issue warning and reject adding camps)

• Ensure only existing camps can be input when adding/modifying the camp field of resources (if no camps, issue warning and reject adding resources) [Melanie]

• Ensure that only existing camps can be input when adding/modifying the camp field of refugees (if no camps, issue warning and reject adding resources)

• Ensure camp capacity is not exceeded when adding refugees to a camp

• Editing camp capacity -> Check against current population (do not allow setting values lower than current population)

• Delete cascade camps and refugees when delete plan (issue a relevant warning when deleting plan)

• Delete cascade refugees when delete camp (issue a relevant warning when deleting camp) [Melanie]

[nghugo]

• Ensure that when camp_id changes, all refugees are relocated
• Ensure that when camp_id changes, all resources are relocated
• Ensure that when plan_id change, all camps are relocated

[nghugo]

All above done except:

• Ensure only existing camps can be input when adding/modifying the camp field of resources (if no camps, issue warning and reject adding resources) [Melanie]