Description:
To support Phase 1 (Pen Pal), we need a basic database schema to store user profiles and their interaction history.
Proposed Tables:
- Users: Basic metadata (respecting privacy/anonymity).
- Conversations: Links users to message sessions.
- Messages: Stores the content of exchanges (Local-first storage).
Deliverable:
A schema.sql file or SQLAlchemy models in the /backend/models directory.
Description:
To support Phase 1 (Pen Pal), we need a basic database schema to store user profiles and their interaction history.
Proposed Tables:
Deliverable:
A schema.sql file or SQLAlchemy models in the /backend/models directory.