php - If you build an online examination system, how should you store indefinite multiple-choice questions?

Question

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.

Answer 1

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

Answer 2

You can also just split it with commas and save it

Answer 3

json structure storage [{"question_id":"1","answer":"A,B,C"},{"question_id":"2","answer":"B,C,D"}]

Answer 4

It feels easy to just divide it up