I am currently working on an online examination system. The test questions are very open. Multiple-choice questions not only have options, but also open options
For example, in a question, ABCDE option E is, do you have any other good ideas for options like ________, and this option is also indefinite. Is there any suitable storage method? I plan to use json to store it.
过去多啦不再A梦2017-05-17 09:57:53
The key fields are as follows:
| Field name | Field type | Instructions |
|---|---|---|
| id | integer | Question id |
| question | varchar(100) | Title |
| answer_options | text | Answer configuration items, such as single choice, multiple choice, what are the options, or fill in the blanks |
| answers | text | Correct answer |
Just use json to store it. This is how I made an exam system before
为情所困2017-05-17 09:57:53
json structure storage [{"question_id":"1","answer":"A,B,C"},{"question_id":"2","answer":"B,C,D"}]
