Create Table Questions (ID int not null auto_increment,
    SurveyID int not null, QuestionType smallint,
    QuestionText varchar(255), NumberOfChoices smallint, 
    isRequired smallint, primary key (ID), index (SurveyID));

Example 2: The Question table.

Back to Article