[FEAT] [MVP] Implement the database schemas and foundational ORM integration for the approved data model

[nicky-mezzina-lhc]

Motivation

With the data model and API endpoint inventory established and proved, the next step is to add the SQL Alchemy ORM integration to each model.

Proposed Solution

Follow the project structure and rules, and/or establish high quality conventions to implement the ORM segment of the backend MVP.

A local development database can be used, alternatively, set up both development and production compose configuration for Postgres (refer here to another ticket)

Alternatives Considered

This is follows the technical stack decision, SQL Alchemy and the validated data model. It is credible that alternatives would walk back on those decisions.

Acceptance Criteria

• Minimal data operations can be easily added to the routes.
• Foundational business logic is mostly present on the application layer.
• The remaining MVP features to implement are >2 pts, non-trivial or earn their own ticket.

Additional Context