我需要创建一个调查，将答案存储在数据库中.我只是想知道在数据库中实现这一点的最佳方式是什么，特别是在所需的表中.这项调查包含不同类型的问题.例如:注释、多项 Select 题的文本字段，以及可能包含多个答案的问题(即勾选所有适用项).
我提出了两种可能的解决方案:
创建一个包含
我不认为这是最好的方式
我想到的另一件事是
一个简单的例子:
tblSurvey:调查
tblQuestion:QuestionID，SurveyID，QuestionType，问题
tblAnswer:回答，UserID，QuestionID，回答
tblUser:用户ID，用户名
我的问题是
如果有任何 idea 和建议，我将不胜感激.
I think that your model #2 is fine, however you can take a look at the more complex model which stores questions and pre-made answers (offered answers) and allows them to be re-used in different surveys.
- One survey can have many questions; one question can be (re)used in many surveys.
- One (pre-made) answer can be offered for many questions. One question can have many answers offered. A question can have different answers offered in different surveys. An answer can be offered to different questions in different surveys. There is a default "Other" answer, if a person chooses other, her answer is recorded into Answer.OtherText.
- One person can participate in many surveys, one person can answer specific question in a survey only once.
