Develop a database schema to support aggregation of all project data

[theecrit]

Description

Given the complexity of multi-year data across departments, programs, strategies, variable metrics and data sources, it seems like hosting a dedicated database to house all the pulled data will be more efficient for managing and analyzing data as it's collected.

Potential tables

Each of these should have a clear definition.

• fundingAgency: the agency that receives the funds from MZ and oversees the programming
• operatingOrg: the organization that implements the funded program
• program: the specific program that directly provides the services funded
• spendingYear: the year funding was allocated for

Requirements for closing this issue

These can be changed as appropriate.

• A schema that accepts the many different metrics available is mapped out and documented.
• Schema documentation is reviewed with FPS team for troubleshooting.
• Schema documentation is attached to this issue.
• Next steps for implementing the scheme are identified and documented in one or more issues (e.g. "Choose a database platform").

[theecrit]

Related to #106