Complete Notification Page Functionality (Backend)

[h0ethan04]

Instructions

The notifications component is mostly complete, and now it's time to pull complete the functionality. First, we need to update the databases and backend routes to support the notifications:

• Since the user table doesn’t currently have an “approved” timestamp column or routes to modify the timestamp, add an approved_on column to the database (refer to figma in Resources)
• Modify the POST request for users to insert the time the account was created
• Modify PUT request for users to also update the approved_on column to the current time when the user account is approved
• The Published Schedule database table also doesn’t have a created_on column, add a created_on column to the database (refer to figma in Resources)
• Modify the POST request for Published Schedule entries to include the time the event was created
• Modify the GET/POST/PUT/DELETE requests for Published Schedule to also return the created_on property
• Create a GET request route for Published Schedule to get events that were confirmed within the past week
• Create a GET request route for Published Schedule events that were added in the past week

Acceptance Criteria

• Approving an account updates the approval_on column in the Users DB accordingly
• Creating an account adds the user with correct timestamp
• Published Schedule events are created with correct timestamp

Resources

• Updated DB Model