db schema

[larocquedylan]

1. Users Table: Stores roommate information.

   • user_id (Primary Key): Unique identifier for each user.
   • name: Roommate's name.
   • email: Email for communication.
   • password_hash: Securely stored password hash for authentication.

2. Tasks Table: Details about tasks.

   • task_id (Primary Key): Unique identifier for each task.
   • name: Name of the task.
   • description: Description of the task.
   • frequency: How often the task needs to be done (e.g., daily, weekly).

3. TaskAssignments Table: Who did what task and when and what are the points worth.

   • assignment_id (Primary Key): Unique identifier for each assignment.
   • task_id (Foreign Key): Links to task_id in Tasks Table.
   • user_id (Foreign Key): Links to user_id in Users Table.
   • due_date: When the task is due.
   • completed_date: When the task was actually completed.
   • status: Current status of the task (e.g., pending, completed).