O cenário
An NGO needs to manage field missions, track objectives, and collect situation reports from field staff across multiple locations.
O que há neste desenho
Entenda as decisões por trás dele.
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.