Skip to content

Data Model

Ethan-Strominger edited this page Jan 1, 2022 · 5 revisions

Plan

  • Program (Code, Description)
  • Program -< Questions (Question Text)
  • Stage
  • Questions for Volunteer
  • Questions for Beneficiary
  • Volunteer (hard code some qs)
  • Beneficiary (hard code some qs)
  • Request
  • Volunteer with dynamic Qs
  • Beneficiary with dynamic Qs
  • Request with dynamic Qs
A -< B : A has one or more Bs, every B has an A
B >- A

A o-< B : A has one or more Bs, a B is optionally associated with an A
A -o< B : A has zero or more Bs, every B has an A
A o-o< B: A has zero or more Bs, a B is optionally associated with an A

=========
Questions
=========
Question >- Section >o-o Program
                    >--- Resource (Program, Volunteer, or Beneficiary)

===================
Request Assignments
===================

Version 1
----------
Request >--- Volunteer
        >--- Beneficiary 

Version 2
---------
Request >- Request Assignment -< Volunteer
        >- Beneficiary


=============================
Volunteer Program Assignments
=============================
Volunteer --< Program Assignment >-- Program

======
People
======
User -o Volunteer
     -o Beneficiary
     -o Director
     -o Manager

Rule: Can't be both a director and a manager, other combos should be okay

Clone this wiki locally