Database models

NGO

An NGO has basic information and related fields to needs (e.g.: 10 syringes, 1 ventilator, etc.), requests from persons (e.g.: Carmen needs one pack of Ibuprofen) and payment methods (PayPal and Netopia specific integration tokens).

Fields

• name
• description
• email
• phone number
• avatar (image field)
• address
• city
• county
• needs (related name to NGONeed)
• requests (related name to PersonalRequest)
• payment methods (related name to NGOPaymentMethod)

NGOPaymentMethod

TODO: Description

TODO: Fields

NGONeed

Describe what an NGO actually needs. It can be of type: resource (physical/material, excluding money), volunteer (people) or money. Fields

• NGO (foreign key to NGO)
• description
• kind (ENUM: resource, volunteer, money) default: resource
• urgency (ENUM: critical, high, medium, low) default: low
• resolved_on

PersonalRequest

Describe what a person needs from a certain NGO or whoever can help. It contains some basic information related to the contact person and a description of the request. A PersonalRequest can also be bound to an organization or institution (e.g. regional hospitals).

• name
• email (nullable)
• phone
• city
• county
• address (nullable)
• organization (nullable)
• description
• NGO (foreign key to NGO, nullable) default: None
• kind (ENUM: resource, volunteer, money) default: resource
• urgency (ENUM: critical, high, medium, low) default: low

Volunteer

A bind between an NGONeed and an outside person or organization.

• organization (nullable)
• name
• email
• phone
• city
• county
• address
• NGO (foreign key to NGO)
• kind (ENUM: resource, volunteer, money) default: resource