DSC-McMaster-U / ai-journal

AI-assisted journaling and mood-tracking application
8 stars 0 forks source link

[TASK-15] Implement Activities Table and API #35

Open abedmohammed opened 5 days ago

abedmohammed commented 5 days ago

[TASK-15] Implement Activities Table and API

Goal:
Create the activities table and develop API endpoints for managing activity entries.

Requirements:

  1. Create Activities Table with Basic Structure:
    image

    • Ensure each activity entry is linked to a dailyRecordID to associate it with a specific day.
    • For now, use boolean columns to represent individual activities (e.g., "Exercise", "Reading", "Meditation").
  2. Activities API - Create Activity Entry:

    • Allow users to create an activity entry linked to a daily record for the current date.
    • Include a restriction to ensure activity entries are associated only with a valid dailyRecordID.
    • there can only be one activity entry per dailyrecord
  3. Activities API - Edit Activity Entry:

    • Allow users to edit an existing activity entry, updating activity statuses as needed.
  4. Activities API - Delete Activity Entry:

    • Implement functionality to delete an activity entry by id.

Expected Outcome:
An activities table with API endpoints for creating, editing, and deleting activity entries, ensuring they are linked to a daily record for the current date.

ausbennett commented 3 days ago

May I take this?

abedmohammed commented 1 day ago

Sorry i forgot to assign this to matthew, but i can also add more tickets to the board for backend stuff