El escenario
An NGO needs to manage field missions, track objectives, and collect situation reports from field staff across multiple locations.
Qué hay en este dibujo
Lee las decisiones que hay detrás.
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.