多个mysql表与单个表设计

Question

I'm looking into building a small survey system and i was wondering what would be the best design for the database based on: Each question can have a certain type of form for submit the answer.

• Checkbox fields
• Radio fields
• input field
• dropdown field

At first i was thinking since i'm using doctrine to create an entity for each type of field and save it into a separate table. The seconds option i was thinking would be to throw all the answers i set for a question in a single table and have a type field for the question where i tell it in the form of integer what form layout should load.

What do you think guys how should i do this ?

Answer 1

You should have one table Called Questions_Answer with entities as the number of options given for the checkboxes,radioField. Like Answer 1, Answer 2. And since the number of answer can vary, u can add the columns, using the ALTER TABLE Questions_Answer ADD column_name datatype