情境
A civil protection agency needs a database schema to coordinate disaster response, shelter occupancy, evacuee registration, and on-site medical assistance.
這張圖裡有什麼
看懂背後的決策。
01
Introduced a Registration join table to model the many-to-many relationship between evacuees and shelters over time.
02
Separated MedicalAssistance as its own entity to track triage, treatment, and referring medical facility independently.
03
Linked Staff and Supply directly to Shelter to reflect operational assignment and resource stocking at specific locations.
Use this structure when modeling disaster response systems that require tracking people, facilities, resources, and medical care across multiple shelters and events.