🤝 Non-profit & NGO · Database ERD
NGO Beneficiary Records Schema
A schema for tracking an NGO's beneficiaries and the services they receive across programmes, for impact reporting.
Drawing diagram…
What this diagram shows
- Households group individual beneficiaries
- Enrolments link beneficiaries to programmes
- Service records and outcomes feed impact reports
Prompt used
ERD for beneficiary records: Household has Beneficiaries (with consent recorded); Programme (education, health, livelihoods) runs at Locations; Enrolment links a Beneficiary to a Programme with dates; ServiceRecord logs each service delivered (session, kit, check-up) by a StaffMember; OutcomeMeasure records baseline and follow-up indicators per enrolment.
Mermaid code
erDiagram
HOUSEHOLD ||--|{ BENEFICIARY : includes
PROGRAMME ||--o{ ENROLMENT : enrols
BENEFICIARY ||--o{ ENROLMENT : "joins"
LOCATION ||--o{ PROGRAMME : hosts
ENROLMENT ||--o{ SERVICE_RECORD : receives
STAFF_MEMBER ||--o{ SERVICE_RECORD : delivers
ENROLMENT ||--o{ OUTCOME_MEASURE : measures
BENEFICIARY {
int id PK
int household_id FK
string name
string gender
bool consent_given
}
ENROLMENT {
int id PK
int beneficiary_id FK
int programme_id FK
date enrolled_on
}
SERVICE_RECORD {
int id PK
int enrolment_id FK
string service_type
date delivered_on
}
OUTCOME_MEASURE {
int id PK
int enrolment_id FK
string indicator
decimal baseline
decimal follow_up
}Related templates
Online Donation Flow
How a donor gives online to an NGO: choosing a cause, paying by UPI or card, and getting a tax-exemption (80G) receipt automatically.
NGO Fund Allocation Sankey
Where an NGO's money comes from and where it goes: donations, grants and CSR funds flowing into programmes, operations and fundraising.
Donor Management Platform
An NGO's fundraising platform: donation pages, donor CRM, recurring giving, tax receipts and impact reporting to donors.
Grant Application Lifecycle
The states of a grant, seen from the NGO applying for it: from concept note to award, reporting and close-out.
Volunteer Onboarding Workflow
How an NGO takes a volunteer from sign-up to first assignment: screening, background check for child-facing roles, training and matching.
NGO Programme Monitoring Data Flow
How field data from an NGO's programmes flows from mobile surveys to dashboards and donor reports.