السيناريو
An NGO needs to manage field missions, track objectives, and collect situation reports from field staff across multiple locations.
ما الذي يتضمنه هذا الرسم
اقرأ القرارات الكامنة وراءه.
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.