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.
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 ?
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