New TODOs

Priority

Re-write db schema in a ddl file to have less redundancy
- Set up db in postgres
- Edit/delete data dictionary - might be useful as reference when getting data from the db into ts objects
- Add a function that adds a job to featured/archived
Fix query/mutations based on new schema
- Use pg full text search to find jobs that align with scholar views
- Implement the count page views function
  - Everytime someone navigates to the page, call the function to increment the count
- Implement the send email function
- Write tests for server/database w/ mock data
Add authentication (Can I use SSO? or maybe next auth?)
- See if its possible to do SSO with hubspot/use hubspot auth
- Get admins to use a username and password and then give them a token (don't use hubspot auth)

Figure out how to make tests work with serverless
Add queries beyond CRUD
Write all query/mutation hooks for frontend
- Note: For some of the mutations (e.g. adding jobs), will likely need to combine querys to allow for a better user experience. E.g. inputting an employer name when adding a job rather than an employer id.
Redeploy to AWS

Add a BE function to look through the views of each scholar and return the jobs that align with their views
- Return scholar name, company, and the jobs that align with their views
- Limit to 5 jobs per scholar
Make the filters more fuzzy, ie. not all criteria has to match

Add apple MSFT and google auth bc theyre students <- Need onyx cc
CRON job to send emails
Add password login for admins
- Add valid admin email list to the database
- Add frontend creation/login flow for admin
- Add a hash for the password
- Add a way to reset password
Add semantic search
Link bookmarking to backend
Add a view creation on signup

Michael's Hours: