DATABASE
Humanitarian Field Mission Reporting Database ERD
A worked database example, rendered live. Open it in the AI editor and adapt it to your own case.
Make this diagram your own.
Open it in the AI editor with a prompt pre-filled — keep what works, change what doesn't.
CASE ANALYSIS
Scenario
An NGO needs to manage field missions, track objectives, and collect situation reports from field staff across multiple locations.
Key decisions
- Separate SituationReport from FieldReport to store narrative security context while FieldReport captures routine activity logs.
- Use many-to-one relationships from reports to Mission, NGOUser, and Location to reflect repeated submissions by multiple staff across locations.
When to reuse this
Use when designing a reporting database for field operations where reporting entities share mission, author, and location dimensions.
Open this example in the editor →
Tweak it with chat, export PNG/SVG, or fork it for your own use case.
erd-humanitarian-ngo-field-mission-reporting-database-schema-for