[Issue]: Database schema diagram and documentation #17

Branch

feature/database-schema-diagram

Task

Description
Produce a clear diagram and short documentation of the full schema, so it can be presented to Nafissa at the end of the sprint. For DB schemas we use https://dbdiagram.io/

Scope

• Diagram of all tables and relationships
• Short description of each table
• Add both to the project documentation

Acceptance Criteria

• The diagram matches the migrations

• The documentation is readable by non-developers

• It is ready to be presented to Nafissa

Checklist

• I have checked for duplicate issues.
• I have assigned the issue to the correct project board.
• I have tagged the issue properly.

Code of Conduct

• I agree to follow this project's Code of Conduct