Storing a snapshot of quizzes and responses in a PostgreSQL database
I am building an application that allows users to create quizzes and other users to solve them. The quizzes are stored in a PostgreSQL database. I would like to store a snapshot of the quiz, including questions and answers, when someone takes the quiz. This way, even if the candidate later edits or deletes the questions or answers, I can still accurately evaluate and display the responses based on the original quiz content.
How can I best structure my tables to store both the quiz data and recruiter responses while maintaining the integrity of the data when the original questions or answers are modified or deleted?
Current Table Structure:
quiz_take_open_answer
quiz_take_closed_answer
quiz_take
quiz_answers
quiz_questions
Any suggestions or best practices to achieve this would be greatly appreciated. Thank you!
0 Replies