Db Schema

1. Understand the exact entities and relationships required by the user.
2. Draft a normalized relational structure or optimal NoSQL document model.
3. Write out the raw SQL statements (CREATE TABLE) or Prisma/Mongoose schemas.
4. Suggest indexes for performance optimization based on queried fields.