Storing Multiple Survey Formats and Answers

I am writing a web application with a MySQL backend that will have multiple users taking various surveys. Each survey has a different number of questions; each question has two types of answers: string and enum; each enum has different numbers of values.

I want to be able to dynamically create the survey, assign questions, set question types (string/enum), assign enum variables if necessary, and save the data for each survey.

I am completely lost as to how the structure of the database should be in order to account for the different types of questions and answers. Help is greatly appreciated.

re: Storing Multiple Survey Formats and Answers

Here's a quick mockup

table: survey
table: questions
table: results

That's probably the quick bare bones way i'd attack it. Though you can get very complex with survey collection data. Another way to quickly learn db schema for survey applications is browse through the db schema of an opensource survey application. Try freshmeat or sourceforge to find one