questionairre - Laravel Schema Designer

respondent

id increments
timestamps timestamps
name string
emailaddress string

Questionnaire

id increments
timestamps timestamps
published boolean
valid_from datetime
valid_to datetime
name string
description string

Question

id increments
timestamps timestamps
question string
description string
question_type ^FK integer
questionnaire_id ^FK integer

Question_type

id increments
timestamps timestamps
question_type_name string
question_type_description string
question_type_scale integer

Question_answers

id increments
timestamps timestamps
answer_name string
answer_description string
question_id ^FK integer

Answer

id increments
timestamps timestamps
question_id ^FK integer
open_answer string
multi_answer ^FK integer
questionnaire_id ^FK integer
answered_questionnaire_id ^FK integer

Answered_Questionnaires

id increments
timestamps timestamps
respondent_id ^FK integer

Preview_Questionnaire

id increments
timestamps timestamps
url string
questionnaire_id ^FK integer

Questionnaire_rule

id increments
timestamps timestamps
if_question_id ^FK integer
if_answer_id ^FK integer
then_question_id ^FK integer
then_answer_id ^FK integer
questionnaire_id ^FK integer

Questionnaire_rules_action

id increments
action_name string
action_name_description string

Questionnaire_rule_action

rule_id ^FK integer
action_id ^FK integer

Question_question_type

question_id ^FK integer
question_type_id ^FK integer

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01