Data structure design of the questionnaire System

Questionnaire:

Title: Questionnaire title

Description: Questionnaire description

Is_complete: whether to complete

Created: Creation Time

Questionnaire question type:

Name: Question type name

PS: The Question Types generally include single choice, multiple choice, blank filling, date, email, etc.

Questionnaire:

Title: Question title

Wenjuan_id: Questionnaire ID

Type_id: Question type ID

Index: Question number (question number)

Is_bitian: Required

Questionnaire question options:

Title: Option title

Question_id: Question ID

Index: option number

Is_blank: Indicates whether an input box exists.

Is_bitian: whether the input box is required

Questionnaire Writer:

PS:The session ID is used for open answer.

Session: Session ID

Wenjuan_id: Questionnaire ID

Created: Enter the time

Questionnaire details:

Session_id: writer ID

Question_id: Question ID

Answer: Question content

Ext: content entered in the input box