[Database]: Create Scheduled Recipes Model in DB

[aleish-m]

Description

Database Table - Scheduled Recipes

:x: New route	:x: An existing route	:white_check_mark: Design/Build/Database

Feature description

Create the Scheduled Recipes Model in Repo using PostgreSQL DB

• A user has many scheduled recipes, and a scheduled recipe belongs to a user's recipes
  • This table is to keep track of when a user schedules a recipe
  • All scheduled recipes are saved as a users recipe regardless of if they are a favorite
  • A favorited recipe does not need to have ever been scheduled
  • A recipe can be scheduled multiple times, and this should be tracked separately _{(eg: Spaghetti can be scheduled on Monday, and this would be saved. Then the user can choose to schedule Spaghetti again on Wednesday. This should not remove it from being scheduled on Monday but rather create a new scheduled instance. However, if the Spaghetti on Monday is changed to be on Wednesday, this would update the existing instance.)}

1. Needs the following attributes:
   • [ ] User Saved Recipe ID - Foreign Key
   • [ ] Schedule Date - DateTime
   • [ ] Timestamps (created/updated) - DateTime
2. Look into indexing on the scheduled date or other options to make looking up recipes scheduled by date more efficient. (We will need to do this ALOT on every page view.)
3. Test for validations
4. Test happy / sad / and edge cases
5. Add Documentation as and if needed

Remember: Use GitHub branch creation for naming

Anything else?

No response