Hi

I'm designing a database app to store questionnaires/surveys/perfomance evaluations kind of things. I've been thinking about a design that would allow users to create new surveys and store the answers from other users.

I wanted a design that allows multiple types of questions (e.g. multi choice, text answer, boolean, mulitpart answers etc..) . I suppose I could use an "Answers table" with a few text fields and use single table inheritance to interpret the fields.

However, questionnaires etc must be a fairly common design pattern and there is probably a better way to do it, I wondered if someone could point me to some examples. Or at least give me a few names of patterns to go hunting for.


Regards

Caius

I don't suppose you tried searching the forum for the word "questionnaire"?