The scenario
An NGO needs to manage field missions, track objectives, and collect situation reports from field staff across multiple locations.
What is in this drawing
Read the decisions behind it.
01
Separate SituationReport from FieldReport to store narrative security context while FieldReport captures routine activity logs.
02
Use many-to-one relationships from reports to Mission, NGOUser, and Location to reflect repeated submissions by multiple staff across locations.
Use when designing a reporting database for field operations where reporting entities share mission, author, and location dimensions.
More like this