Donor Management

Overview

Nonprofit donor management and fundraising CRM schema. Tracks donors, campaigns, donations, pledge fulfillment, grant management, volunteer hours, and program impact metrics.

Key Design Decisions

• Donor Segments: Tag-based segmentation for targeted campaigns and communications
• Pledge Fulfillment: Multi-payment pledge tracking with reminder scheduling
• Grant Lifecycle: Grant applications through reporting with milestone tracking
• Impact Metrics: Program-level impact measurement tied to funding sources

Tables

12-14 tables covering donors, donor segments, campaigns, donations, pledges, pledge payments, grants, grant reports, volunteers, volunteer hours, programs, and impact metrics.