users_master
user_id (PK)
full_name
gender
age
phone
address
role
created_at
warehouses
warehouse_id (PK)
name
location
max_capacity
current_status
supervisor_id (FK → users_master.user_id)
food_categories
category_id (PK)
category_name
storage_type
required_storage_temperature
inventory_items
item_id (PK)
name
quantity_kg
warehouse_id (FK → warehouses.warehouse_id)
category_id (FK → food_categories.category_id)
expiry_date
donations_log
donation_id (PK)
donor_name
amount_value
donation_type
org_type
donated_at
beneficiary_details
beneficiary_id (PK)
user_id (FK → users_master.user_id)
family_members_count
poverty_score
last_received_date
skills
skill_id (PK)
skill_type
volunteer_skills
volunteer_skill_id (PK)
volunteer_id (FK → users_master.user_id)
skill_id (FK → skills.skill_id)
years_of_experience
training_sessions
session_id (PK)
session_name
trainer_name
session_date
driver_training
driver_id + session_id (PK)
driver_id (FK → users_master.user_id)
session_id (FK → training_sessions.session_id)
vehicle_assignments
vehicle_id (PK)
driver_id (FK → users_master.user_id)
assigned_date