Trust Donor and Seva Database

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
  }