Hello,
I need help to understand how to deal with this project
I have to create an app to manage surveys for commercial activities.
The surveys are made up from about 2000 questions and are dynamically generated according to some initial choices.
The answers that can give the user can be of different types (radio, check, combobox, field text).
What is the best strategy for storing questionnaires and answers?
I believe that the most logical thing would be to memorize the answers in a table like this
| ID
| FK-survey
| FK-question
| answer
But this way I can not manage the various types of fields.
I need help to understand how to deal with this project
I have to create an app to manage surveys for commercial activities.
The surveys are made up from about 2000 questions and are dynamically generated according to some initial choices.
The answers that can give the user can be of different types (radio, check, combobox, field text).
What is the best strategy for storing questionnaires and answers?
I believe that the most logical thing would be to memorize the answers in a table like this
| ID
| FK-survey
| FK-question
| answer
But this way I can not manage the various types of fields.