Database Schema

The schema is defined in the models.py file through SQLAlchemy objects.

To visualize the schema we've used wwwsqldesigner through their hosted instance. We load the database_schema.xml to modify it and save it back as xml in the repo.