情境
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.