questionnaire_survey

0 rows


Description

questionnaire_survey table retrofitted from MySQL

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
questionnaire.sid ques_sid2_fkR
questionnaire_dependency.surveyid quesdepe_sur2_fkR
questionnaire_fb_sections.surveyid quesfbsect_sur2_fkR
name VARCHAR 255
courseid BIGINT 19 √ null
course.id quessurv_cou2_fkR
realm VARCHAR 64
status BIGINT 19 0
title VARCHAR 255
email VARCHAR 255 √ null
subtitle LONGTEXT 2147483647 √ null
info LONGTEXT 2147483647 √ null
theme VARCHAR 64 √ null
thanks_page VARCHAR 255 √ null
thank_head VARCHAR 255 √ null
thank_body LONGTEXT 2147483647 √ null
feedbacksections TINYINT 3 √ 0
feedbacknotes LONGTEXT 2147483647 √ null
feedbackscores BIT 1 √ 0
chart_type VARCHAR 64 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quessurv_cou2_ix Performance Asc courseid
quessurv_nam2_ix Performance Asc name

Relationships

Close relationships within degrees of separation