CloudSketch AI Logo
FeaturesTemplatesPricingEnterpriseAboutContactLog in
🌙☀️
Log inStart free
Home/Templates/Religious & Spiritual Organisations

🛕 Religious & Spiritual Organisations · Database ERD

Trust Donor and Seva Database

Tables for a religious trust: devotees, donations to causes, receipts, seva bookings and volunteer shifts.

More Religious & Spiritual Organisations templates

Opening a template is free and never counts toward your daily diagrams. Asking the AI to change it counts as one.

Drawing diagram…

What this diagram shows

  • One devotee record links donations, sevas and volunteering
  • Every donation has a receipt number for audits
  • Seva bookings are tied to a date and slot

Prompt used

Trust database: devotees make donations to causes and receive receipts; devotees book sevas (poojas) for a date and slot; volunteers sign up for shifts at events.

Mermaid code
erDiagram
  DEVOTEE ||--o{ DONATION : gives
  CAUSE ||--o{ DONATION : receives
  DONATION ||--|| RECEIPT : "acknowledged by"
  DEVOTEE ||--o{ SEVA_BOOKING : books
  SEVA ||--o{ SEVA_BOOKING : "booked as"
  DEVOTEE ||--o{ VOLUNTEER_SHIFT : serves
  EVENT ||--o{ VOLUNTEER_SHIFT : needs
  DEVOTEE {
    int id PK
    string name
    string mobile
    string pan
    string city
  }
  CAUSE {
    int id PK
    string name
  }
  DONATION {
    int id PK
    int devotee_id FK
    int cause_id FK
    decimal amount
    date donated_on
    string mode
  }
  RECEIPT {
    int id PK
    int donation_id FK
    string receipt_no
    boolean is_80g
  }
  SEVA {
    int id PK
    string name
    decimal fee
  }
  SEVA_BOOKING {
    int id PK
    int devotee_id FK
    int seva_id FK
    date seva_date
    string slot
  }
  EVENT {
    int id PK
    string name
    date event_date
  }
  VOLUNTEER_SHIFT {
    int id PK
    int devotee_id FK
    int event_id FK
    string role
    string shift
  }

Inside this diagram

An entity relationship diagram with 8 tables, 33 columns and 7 relationships.

Tables and their columns

  • DEVOTEE: id (PK), name, mobile, pan, city
  • DONATION: id (PK), devotee_id (FK), cause_id (FK), amount, donated_on, mode
  • CAUSE: id (PK), name
  • RECEIPT: id (PK), donation_id (FK), receipt_no, is_80g
  • SEVA_BOOKING: id (PK), devotee_id (FK), seva_id (FK), seva_date, slot
  • SEVA: id (PK), name, fee
  • VOLUNTEER_SHIFT: id (PK), devotee_id (FK), event_id (FK), role, shift
  • EVENT: id (PK), name, event_date

Relationships

  • DEVOTEE gives DONATION: each DEVOTEE has zero or more DONATION, each DONATION belongs to exactly one DEVOTEE
  • CAUSE receives DONATION: each CAUSE has zero or more DONATION, each DONATION belongs to exactly one CAUSE
  • DONATION acknowledged by RECEIPT: each DONATION has exactly one RECEIPT, each RECEIPT belongs to exactly one DONATION
  • DEVOTEE books SEVA_BOOKING: each DEVOTEE has zero or more SEVA_BOOKING, each SEVA_BOOKING belongs to exactly one DEVOTEE
  • SEVA booked as SEVA_BOOKING: each SEVA has zero or more SEVA_BOOKING, each SEVA_BOOKING belongs to exactly one SEVA
  • DEVOTEE serves VOLUNTEER_SHIFT: each DEVOTEE has zero or more VOLUNTEER_SHIFT, each VOLUNTEER_SHIFT belongs to exactly one DEVOTEE
  • EVENT needs VOLUNTEER_SHIFT: each EVENT has zero or more VOLUNTEER_SHIFT, each VOLUNTEER_SHIFT belongs to exactly one EVENT

Make your own diagram like this

Describe your own system in plain English and the AI ER diagram generator draws it in seconds, in the same style as this template.

Related templates

C4 ArchitectureProReligious & Spiritual Organisations

Temple Management Platform

A digital platform for a large temple trust: darshan and seva bookings, online donations with tax receipts, prasad orders, accommodation and crowd information.

SequenceReligious & Spiritual Organisations

Darshan Slot Booking Sequence

How a devotee books a special darshan slot online: choosing a date, ID verification, holding the slot during payment and getting a QR ticket for entry.

FlowchartReligious & Spiritual Organisations

Online Donation with 80G Receipt

How an online donation to a religious trust is processed, from choosing a cause to issuing an 80G tax receipt and filing donor details with the tax department.

DeploymentProReligious & Spiritual Organisations

Festival Crowd Management

The systems used to manage crowds during a big festival or yatra: cameras, turnstiles and sensors in the field, a command centre, and alerts to police and volunteers.

State MachineReligious & Spiritual Organisations

Prasad Order by Post

The states of a prasad order sent by post to a devotee, from payment to delivery, including returns for wrong addresses.

FlowchartReligious & Spiritual Organisations

Community Kitchen (Annadanam / Langar) Planning

How a community kitchen plans daily meals: expected footfall, ingredient stock, donations in kind, cooking batches and leftovers going to shelters.