Scribd
Upload
13 views1 page

Disaster Management Database Schema

The document outlines a database schema for managing disaster-related information, including users, donations, shelters, alerts, locations, agencies, medical camps, resources, and volunteers. Each entity has specific attributes such as IDs, names, dates, and capacities, along with indexes for efficient data retrieval. The schema facilitates the organization and tracking of various aspects of disaster management and response.

Uploaded by

Sadman
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
13 views1 page

Disaster Management Database Schema

The document outlines a database schema for managing disaster-related information, including users, donations, shelters, alerts, locations, agencies, medical camps, resources, and volunteers. Each entity has specific attributes such as IDs, names, dates, and capacities, along with indexes for efficient data retrieval. The schema facilitates the organization and tracking of various aspects of disaster management and response.

Uploaded by

Sadman
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Disaster

Users disaster_id INT


user_id INT type VARCHAR(50)
name VARCHAR(100) severity VARCHAR(50)
email VARCHAR(100) start_date DATE
phone VARCHAR(20) end_date DATE
role VARCHAR(50) location_id INT
Indexes Indexes

Donation Shelter
donation_id INT shelter_id INT
donor_name VARCHAR(100) name VARCHAR(100)
amount DECIMAL(12,2) capacity INT
Alert
date DATE location_id INT
alert_id INT
agency_id INT Indexes
Location
disaster_id INT
Indexes
location_id INT message TEXT
name VARCHAR(100) issued_at TIMESTAMP
district VARCHAR(100) Indexes
division VARCHAR(100)
latitude DECIMAL(10,7)
longitude DECIMAL(10,7)
Indexes

AgencyNGO MedicalCamp
agency_id INT camp_id INT
name VARCHAR(100) disaster_id INT
contact_info VARCHAR(150) agency_id INT
location_id INT location_id INT
Indexes start_date DATE
end_date DATE
Resource
Indexes
resource_id INT
name VARCHAR(100)
category VARCHAR(50)
quantity INT
unit VARCHAR(20)
Indexes
Volunteer
Transportation ResourceAllocation
volunteer_id INT
transport_id INT allocation_id INT
user_id INT
type VARCHAR(50) resource_id INT
agency_id INT
capacity INT disaster_id INT
skills VARCHAR(200)
agency_id INT volunteer_id INT
availability_status VARCHAR(50)
Indexes allocation_date DATE
Indexes
quantity INT
Indexes

You might also like