Currently, data for our interviews is only stored in three fields in the reviews table (interviewRating, interviewDifficulty, and interviewReview). To accommodate ratings for multiple interview rounds connected to one review, we need to make a separate table for interview rounds, which can be linked to one review.
Each interview round should have an interview type, difficulty rating, and be linked to a specific review. Check with Sophia (the person who designed the review form) for specifics about how interview type and difficulty rating should be represented.
Note: since modifying the review/interview schema would break the current endpoints, we won't be merging this into main till the other subissues are completed on top of this
Currently, data for our interviews is only stored in three fields in the reviews table (interviewRating, interviewDifficulty, and interviewReview). To accommodate ratings for multiple interview rounds connected to one review, we need to make a separate table for interview rounds, which can be linked to one review.
Each interview round should have an interview type, difficulty rating, and be linked to a specific review. Check with Sophia (the person who designed the review form) for specifics about how interview type and difficulty rating should be represented.
Note: since modifying the review/interview schema would break the current endpoints, we won't be merging this into main till the other subissues are completed on top of this