Develop a survey system (magento 2).
Planned for the time table:
- questions for the surveys;
You also need to provide for the amendment of questions to the survey after you already have the answers. Namely, I would like to keep history for answers to already existing questions (for displaying in the admin).
Any idea of the history table where there are answers (and questions) in the text without reference to the questions. I.e. there is a duplication in the event of any changes in the issues.
Of the minuses: after any change will need to take all answers of users and record again. Is too bloated.
p.s. Came up with the idea to keep the answers only for questions that were changed or removed, i.e. like in git.
Here's another idea: if there is a need to change anything in the poll, you need to create a new one. Not to worry with getting the same questions, table questions unbinds from surveys and serves only as a dictionary from which to get a question in a new poll.
Of the minuses: even with a dictionary it is not that easy to change in 1 case.
Pros: easy to store, don't even need the extra table.