database.md

Database

Schema

The database schema is defined in app/db/models.py and is managed by Alembic. The migrations are stored in app/db/migrations/versions

Entity Relationship Diagram

See Here

Recreate Local DB

For DATABASE_URL, drop the database if it exists and then recreate it.

Init migrations

Deletes the versions directory and runs migrate() to generate a new intial migration version for the SQLAlchemy models.

Create Test Data

Inserts a set of seed data comprising one Fund, 2 rounds and the applicaiton/assessment config for one of those rounds. The data created is defined in test_data.py