presentation_options
)
survsimp_question_choices
)
survsimp_question_choices
)
survsimp_question_choices
)
survsimp_questions
-- questions for each survey
survsimp_surveys
-- specs for one survey form (except the questions)
survsimp_responses
-- user responses to surveys
survsimp_question_responses
-- user responses to
individual questions within a survey
survsimp_question_responses
table five columns.
Only one of the columns will be not-null.-- if the user picked a canned response choice_id references survsimp_question_choices, boolean_answer char(1) check(boolean_answer in ('t','f')), clob_answer clob, number_answer number, varchar_answer varchar(4000),
Why the CLOB in addition to the varchar? The CLOB is necessary when people are using this system for proposal solicitation (people might type more than 4000 characters).
If Buddy never gets his act together, we should add a feature to this system whereby a multiple-choice question can solicit a typed-in "Other" answer as well.